MySQL°æ±¾ÎÊÌ⣿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
ÎÒÊÇwindows7²Ù×÷ϵͳ£¬ÕýÔÚѧϰjsp£¬ÓõÄÊÇtomcat6·þÎñÆ÷
µ«ÊÇmysqlÊý¾Ý¿â²»ÖªµÀÓÃÄĸö°æ±¾£¬¿´µ½ÍøÉÏÓкö࣬ÊìϤµÄ°ïæ½éÉÜÏ£¬Ð»Ð»
ÎÒÃÇÀÏʦ½²¿Îʱ£¬¸øÎÒÃÇʾ·¶¹ýÒ»¸ö£¬Ö»¼ÇµÃÄǸöûÓнçÃæ£¬È»ºóÀÏʦÓÖ°²×°ÁËÒ»¸ö½çÃæ
mysql 5.1
Äĸö°æ±¾ÄØ
MySQL Community Server
MySQL Cluster
MySQL Workbench
MySQL Community Server
mysql-5.1.30-win32
MySQL-5.1.30(gz)
mysql-5.0.22(gz)
mysql-5.0.22-win32
mysql-noinstall-5.0.22(win32)
MySQL-server-5.0.22
MySQL-bench-5.0.22
MySQL-client-5.0.22
MySQL-devel-5.0.22
MySQL-shared-5.0.22
²»ÖªµÀÕâЩÊÇʲô¶«Î÷°¡
http://dev.mysql.com/downloads/mysql/5.1.html
(mysql-essential-5.1.42-win32.msi)
(mysql-5.1.42-win32.msi)
ÕâÁ½¸öÓÐÊ²Ã´Çø±ðô
Ò»¸ö½ö°üÀ¨×îСµÄ°²×°£¬ÁíÒ»¸ö°üº¬ÆäËü¹ÜÀí¹¤¾ßµÄÃüÁî¡£
(mysql-5.1.42-win32.msi)
3q
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......