mysql ÈçºÎÕû¸ö¿âËÑË÷
ÈçºÎ¶ÔmysqlÕû¸ö¿âËÑË÷ Èç¹Ø¼ü×Ö ¡°Ð¹ɷ¢ÐС±
Õû¸ö¿â£¿ÊDz»ÊÇ˵ij¸ö±íµÄËùÓÐ×ֶΣ¿
¶÷£¬ÊÇËùÓÐ×Ö¶Î ²¢ÇÒ ËùÓбí
Èç¹ûÄãÓóÌÐòµÄ»°£¬¿ÉÒÔÓÃsqlÓï¾äshow databases£¬È»ºó°´ÕÕ²é³öµÄ½á¹û¼¯£¬Ò»´ÎµÄshow tables,È»ºóÔÙÒ»´ÎÈ¥²éÕÒÄãµÄ¼Ç¼£¬ÊDz»ÊÇ¿ÉÒÔʹÓÃÈ«ÎÄË÷Òý£¬»¹ÊÇÄãÔÙÒ»´Îµü´údesc [tableName]È¥²éÕÒÿһ¸ö×Ö¶ÎÄØ£¬¿´ÄãÁË
Ŷ£¬ºÃ·½·¨£¬Ì«¸ÐлÁË ÓÖѧϰÁËinformation_schemaÕâ¸öÐéÄâÊý¾Ý¿âµÄ×÷Óã¬ÒÔǰû·¢ÏÖ£¬ÏÖÔÚÊDzËÄñÒ»¸ö
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......