MYSQL»ù´¡ÎÊÌâ
н¨Ò»¸ö±ítable ×Ö¶ÎÓÐ:×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3 ×Ö¶Î4 ×Ö¶Î3ÀïÃæÎÒ´æµÄÊý¾ÝÒ²ÊÇÒ»Õűí Ôõô´æ ×Ö¶ÎÈýµÄ±íÒѾ½¨ºÃ Ãû×ÖÊÇtable3 ÊÇÐÞ¸Ä×Ö¶Î3µÄÊý¾ÝÀàÐÍÂ𣿠ĬÈϵÄÊÇvarchar Ó¦¸Ã¸Ä³Éʲô£¿£¿£¿£¿£¿
¾ÙÀý˵Ã÷ÒªÇó insert into select ? Áí½¨Ò»¸ötable3 ±í table±íµÄ ×Ö¶Î3ÉèÖÃΪÍâ¼ü¹ØÁªµ½table3±íµÄid×ֶΠû¿´¶®¡£×Ö¶Î3ÀïÃæÎÒ´æµÄÊý¾ÝÒ²ÊÇÒ»Õűí Ôõô´æ ÊÇÔõôÀí½â£¿¡¡½¨Òé¾ÙÀý˵Ã÷¡£ÒýÓà û¿´¶®¡£×Ö¶Î3ÀïÃæÎÒ´æµÄÊý¾ÝÒ²ÊÇÒ»Õűí Ôõô´æ ÊÇÔõôÀí½â£¿¡¡½¨Òé¾ÙÀý˵Ã÷¡£ table £ºÖ÷Ë÷Òý ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3 ×Ö¶Î4 id ÐÕÃû ÐÔ±ð »ù±¾ÐÅÏ¢±í »é·ñ 1 ÕÅÈý ÄÐ table3 δ»é 2 ÀîËÄ Å® table4 ÒÑ»é table3£ºÖ÷Ë÷Òý ×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3 id ÄêÁä ¹¤×÷µ¥Î» ¼Òͥסַ 1 20 ijµ¥Î» ijµØ 2 21 ijµ¥Î» ijµØ <
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿ ÔËÐÐ ALTER TABLE tablename DROP id; ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......