MySQLµÄ ¸÷°æ±¾Çø±ð
µÚÒ»¸ö MySQL Community Server£¬Õâ¸ö²»ÒªÇ®£¡
µÚ¶þ¸ö MySQL Enterprise Õâ¸öÒªÌÍÇ®£¬²»¹ý¿ÉÒÔ´òµç»°×ÉѯÎÊÌ⣬Ҳ¾ÍÊǵ绰¼¼ÊõÖ§³Ö¡£
µÚÈý¸ö MySQL Cluster£¬Õâ¸öµ¥¶ÀÊÇû·¨Óõģ¬ÒªÔÚ1»ò2µÄ»ù´¡ÉÏÓᣵ±È»ÓÃÀ´Æ½ºâ¶ą̀Êý¾Ý¿âµÄ¡£
µÚËĸö MySQL Workbench£¬ÕâÊǸöºÃ¶«Î÷£¬ÓÃÀ´Éè¼ÆÊý¾Ý¿âµÄ¡£erwinÖªµÀÂð£¿Ëû¾ÍÊÇÕâ¸ö×÷Óá£
MySQL Community Server ÉçÇø°æ±¾ Ó¦¸Ã²»Ìṩ¹Ù·½¼¼ÊõÖ§³Ö
MySQL Enterprise Server MySQLÆóÒµ°æ·þÎñÆ÷
Èí¼þÊÇ×î¿É¿¿¡¢×ȫ¡¢¸üа汾µÄMySQLÆóÒµ¼¶·þÎñÆ÷Êý¾Ý¿â£¬ËüÄܹ»¸ßÐԼ۱ȵØÌṩµç×ÓÉÌÎñ¡¢Áª»úÊÂÎñ´¦Àí(OLTP)¡¢Ç§Õ×¹æÄ£µÄÊý¾Ý²Ö¿âÓ¦Óõȡ£ËüÖ§³ÖACIDÊÂÎñ´¦Àí£¬ÄÜÌṩÍêÕûµÄÌá½»¡¢»Ø¹ö¡¢±ÀÀ£»Ö¸´ºÍÐм¶Ëø¶¨¹¦ÄÜ¡£MySQLÊý¾Ý¿âÒòÆäÒ×ÓÃÐÔ¡¢¿ÉÀ©Õ¹ÐԺ͸ßÐÔÄܵÈÌØµã£¬³ÉΪȫÇò×îÁ÷ÐеĿªÔ´Êý¾Ý¿â¡£
MySQL Cluster 2̨ÒÔÉÏ mysql¼¯Èº·þÎñÆ÷
MySQL WorkbenchÓÐÁ½¸ö°æ±¾£º
MySQL Workbench Community Edition£¨ÓÖ½ÐMySQL Workbench OSS£¬ÉçÇø°æ£©ºÍMySQL Workbench Standard Edition£¨ÓÖ½ÐMySQL Workbench SE£¬ÉÌÒµ°æ£©¡£MySQL Workbench OSSÊÇÔÚGPLÖ¤ÊéÏ·¢²¼µÄ¿ªÔ´ÉçÇø°æ±¾£¬¶øMySQL Workbench SEÔòÊǰ´ÄêÊշѵÄÉÌÒµ°æ±¾¡£Æä¹¦ÄÜ·½ÃæµÄ²îÒì¼ûÏÂ±í£¨²»µÃ²»Ëµ£¬Êý¾Ý¿â/Ä£ÐÍͬ²½ÕâÒ»ÖØÒªµÄ¹¦Äܾ¹È»Ö»ÔÚÊշѵÄMySQL Workbench SEÖпÉÓ㬶øÔÚDBDesigner4ÖÐÕâÈ´ÊÇ»ù±¾¹¦ÄÜ£¬ÕâÖÖ“¼ÌÈΔ·½Ê½ÊµÔÚÈÃÈ˶ñÐÄ);
²¹³ä:
.tgzÊÇÔ´Âë°²×°£¬
glibcÊÇÖ¸C±àÒëÆ÷µÄ°æ±¾ÁË¡£
Essentials ¾«¼ò - È¥³ýÁËʵÀýÎļþ
"noinstall.zip”µÄÊÇ˵¸ÃѹËõ°üÀïÃæµÄÎļþÊDz»Óð²×°µÄ£¬Ö±½ÓʹÓá£
------------------------------------------------------------------------------------------------------------------------------
MySQL-3.23.39-1.i386.rpm £º°üº¬ÔËÐÐMySQL·þÎñÆ÷ËùÐèµÄÈ«²¿Îļþ£¬°üÀ¨¿Í»§»ú³ÌÐò
MySQL-3.23.39-1.src.rpm£º°üº¬MySQLµÄËùÓÐÔ´Âë
MySQL-bench-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ²âÊÔMySQLÐÔÄܵijÌÐò£¬ ÕâЩ²âÊÔ³ÌÐòÐèÒªÖ÷·¢ÐеµºÍPerl
MySQL-client-3.23.39-1.i386.rpm£ºÖ»°üº¬¿Í»§»ú³ÌÐò
MySQL-devel-3.23.39-1.i386.rpm“£º°üº¬±àÒë¿Í»§»ú³ÌÐòËùÐèÒªµÄ¿âºÍÍ·Îļþ
MySQL-shared-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ¿Í»§»ú³ÌÐòµÄ¹²Ïí¿â
¹ØÓÚϵͳ°æ±¾£º
Windows Essentials (x86) 6.0.7 £ºEssentials ¾«¼ò£¬¾«¼ò°æ - È¥³ýÁËʵÀýÎļþ
Windows ZIP/Setup.EXE (x86) 6.0.7£º×Ô¶¯°²×°°æ£¬ÏÂÔØÏÂ
Ïà¹ØÎĵµ£º
Ö÷´Ó·þÎñÆ÷±íÀàÐ͵ÄÑ¡Ôñ
Ò»°ãµÄ¹²Ê¶ÊÇÖ÷·þÎñÆ÷ʹÓÃinnodb£¬ÊÂÎñ£¬ÐÐËøµÈ¹¦ÄÜÊÇmyisamËùûÓе쬶ÔÐ޸IJÙ×÷¶øÑÔ£¬Ëü¸ü¸ßЧ£»´Ó·þÎñÆ÷ʹÓÃmyisam£¬È«ÎļìË÷¹¦ÄÜÊÇinnodbËùûÓеģ¬¶Ô²éѯ²Ù×÷¶øÑÔ£¬Ëü¸ü¸ßЧ¡£ÕâÑù¾Í¿ÉÒÔ¸÷¾¡ÆäÄÜ¡£
ºÇºÇ£¬Ö÷´Ó¿â¸÷˾ÆäÖ°£¬Ö÷¿â£º×î¿ìµÄËÙ¶È×öÌí¼Óɾ³ýÐ޸IJÙ×÷£¬´Ó¿â£¬×î¿ìµÄËÙ¶È×ö²éѯ²Ù×÷
......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£ºhttp://sourceforge.net/projects/mysqldrivercs/ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe using System;using System.Collectio ......
·½·¨Ò»£º
ʹÓÃMySQLÍÆ³öµÄMySQL Connector/Net×é¼þ£¬ ¸Ã×é¼þÊÇMySQLΪADO.NET·ÃÎÊMySQLÊý¾Ý¿âÉè¼ÆµÄ.NETרÓ÷ÃÎÊ×é¼þ¡£Íê³É¸Ã×é¼þºó£¬ÐèÒªÔÚÏîÄ¿ÖÐÒýÓÃÕâ¸ö×é¼þ£¬Ò²¿ÉÒÔÖ±½ÓÔÚÅäÖÃÎļþµÄ<assemblies>½ÚµãÄÚÌí¼ÓÏÂÃæµÄ½Úµã£º
<add assembly="MySql.Data, Version=5.1.5.0, Culture=neutral, PublicKeyToken=C5687 ......
Ô¶³ÌµÇ¼ -h IPµØÖ·
ctrl + d Í˳ö »ò \q »ò quit
select version(); µ±Ç°°æ±¾
current_dateµ±Ç°ÈÕÆÚ »òcurdate() »ò current_date()
SELECT name, birth, curdate(),(year(curdate())-year(birth)) - (right(curdate(),5)<right(birth,5)) as age from ±í ORDER BY name;
year ÌáÈ¡Ä겿·Ö right(curdate(),5)ÌáÈ¡Ó ......