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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......