ÔÚwindowsϰ²×°Ò»¸öMySQLµÄ¶þ½øÖÆ·Ö·¢Ê®·ÖµÄÈÝÒס£Ê×ÏÈÄã±ØÐëͨ¹ýǰÎÄËùÊöµÄ·½·¨»ñµÃÏàÓ¦µÄÈí¼þ°ü£¬ÆäÎļþÃûÓ¦¸ÃÀàËÆÓÚmysql-x.xx.xx-beta-win.zip»òÕßmysql-x.xx.xx-win.zip¡£Èç¹ûÄãÏÂÔØµÄÊǹ²Ïí°æ±¾£¬Ó¦¸ÃÀàËÆÓÚmysq-shareware-x.xx.xx-win.zip¡£ÓÉÓÚMySQLµÄwindows°æ±¾±ØÐÞ¸¶·ÑʹÓ㬹²Ïí°æ±¾ÓÐÉÙÐí¹¦ÄÜÏÞÖÆ£¬Òò´ËÈç¹ûÖ ......
ÎÒÏëÓÃNavicat¿Í»§¶Ë¶ÔMySQLÊý¾Ý¿â½øÐвÙ×÷£¬µ«Á¬½ÓÊý¾Ý¿âʱ±¨ÒÔÏ´íÎó£º
¡°2003 - Can't connect to MySQL server on 'localhost'(10061)¡±
ÒÔÏÂÊÇÎÒ½¨Á¢ÐÂÁ¬½ÓµÄÅäÖãº
Á¬½ÓÃû£ºcon1
Ö÷»úÃû/IPµØÖ·£ºlocalhost
¶Ë¿Ú:3306
Óû§Ãû£ºroot
ÃÜÂ룺ÎÒ°²×°Êý¾Ý¿âʱÊäÈëµÄÃÜÂë
ÉÏÍø²éÁ˲飬˵ÊÇ·þÎñûÆô¶¯£¬µ«ÎҵķþÎñÃ÷à ......
mysql> create table c(id int primary key identity(1,1));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'ident
ity(1,1))' at line 1
create table c(id int primary key identity(1,1)); ÄÄÀ ......
+------+------+-------+
| id | name | bumen |
+------+------+-------+
| 2400 | a | 1 |
| 2300 | b | 1 |
| 2200 | a | 2 |
| 2200 | b | 2 |
+------+------+-------+
´ÓµÚ3¸ö¿ªÊ¼µ½µÚ4¸ö ¸ù¾ÝID ×ܹ²È¡³ö2¸öÊý¾Ý
զд£¿
SQL sever 2000ºÍ MYSQL²î±ðÕæ´ó
......
´ó¼ÒºÃ£º
ÎÒÓýâѹËõµÄ·½·¨°²×°ÁËMySQL Êý¾Ý¿â£¬µ«ÊǸоõÀûÓÃÓï¾äʵÏÖ²Ù×÷ÔÚÒ»¶¨µÄʱºò×ÜÊÇÓе㲻·½±ã£¬ÎÒÏÂÔØÁËMySQL WorkBench£¬ÇëÎÊ£¬ÈçºÎ°²×°½âѹËõ°æµÄMySQL WorkBench£¿Ò²¾ÍÊÇ˵£¬ÈçºÎ½«MySQL WorkBenchÓëMySQLÁ¬½ÓÆðÀ´£¿
лл£¡
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topi ......
ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл
°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã
ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°
mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡
ÌùÓÊÏ䣬·¢Äã
1.mysql api
2.myodbc
......