MYSQL»ù´¡ÎÊÌâ
н¨Ò»¸ö±ítable ×Ö¶ÎÓÐ:×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3 ×Ö¶Î4
×Ö¶Î3ÀïÃæÎÒ´æµÄÊý¾ÝÒ²ÊÇÒ»Õűí Ôõô´æ
×Ö¶ÎÈýµÄ±íÒѾ½¨ºÃ Ãû×ÖÊÇtable3
ÊÇÐÞ¸Ä×Ö¶Î3µÄÊý¾ÝÀàÐÍÂ𣿠ĬÈϵÄÊÇvarchar Ó¦¸Ã¸Ä³Éʲô£¿£¿£¿£¿£¿
¾ÙÀý˵Ã÷ÒªÇó
insert into select ?
Áí½¨Ò»¸ötable3 ±í
table±íµÄ ×Ö¶Î3ÉèÖÃΪÍâ¼ü¹ØÁªµ½table3±íµÄid×Ö¶Î
û¿´¶®¡£×Ö¶Î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ʱ½«Êý¾Ý¿âµÄ×Ö· ......
±í
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 ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
mysqlµÄÖ´ÐÐinsertÊÇ·ñÓзµ»ØÖµ£¿ÏñoracleµÄ·µ»ØÖµÊÇsqlcode£¬
mysqlÓзµ»ØÖµÃ´£¿Âé·³ÄÄλ¸æËßһϡ£
°ï¶¥ MYSQL½¨ÒéÈ¥ÆäËûÊý¾Ý¿â¿ª·¢°æ¿é
mysqlÓзµ»ØÖµÃ´£¿
---
ÎÒÖªµÀmssqlÓУ¬@@error
²»ÖªµÀÓÐûÓÐÀàË ......