¸Ã°²×°ÄĸöMYSQL£¿
ÎÒ×¼±¸ÓÃÒ»ÏÂMYSQL£¬µ«ÊÇÉÏSUNµÄÍøÕ¾ÓÐºÜ¶à°æ±¾£¬ÎÒÖ»ÖªµÀÒªÏÂ32λµÄ£¬µ«ÊDz»ÖªµÀ¾ßÌåÏÂÄĸö²ÅÊÇÍêÈ«°æµÄ£¿Äĸö¸ßÊÖÖ¸µãһϡ£
꿅᣼http://dev.mysql.com/downloads/mysql/5.1.html
Äܲ»ÄܰѸ÷¸ö°æ±¾¶¼½âÊÍһϣ¿
ÄãµÄ²Ù×÷ϵͳÊÇʲô£¿
MySQL Community Server 5.1.42
(mysql-essential-5.1.42-win32.msi) »ù´¡°æ£¬ ½ö°üÀ¨£Í£Ù£Ó£Ñ£Ì±ØÐëµÄ²¿¼þ¡£
(mysql-noinstall-5.1.42-win32.zip)¡¡ÎÞ°²×°°æ£¬¡¡Ö±½Ó£Õ£Î£Ú£É£Ð¼´¿ÉÓ㬵«·þÎñÖ®ÀàÐèÒª×Ô¼ºÊÖ¹¤ÅäÖá£
(mysql-5.1.42-win32.msi) ÍêÈ«°æ
WinXPµÄ
{{
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......