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µØ <
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒÊÇÐÂÊÖ£¬³õѧ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µÄ±àÂë¸ñʽ ......