Help£¡ÈçºÎÅúÁ¿ÐÞ¸ÄmysqlÊý¾Ý¿âÖеÄ×Ö¶ÎÃû
ÏÖÓÐÒ»mysqlÊý¾Ý¿â£¬Êý¾Ý¿âÃûΪcapucivar£¬¸ÃÊý¾Ý¿âÖÐ300ÕÅÊý¾Ý±í£¬ÔÚÕâЩ±íÖÐÓÐÏàͬµÄ×ֶΣ¬±ÈÈçÊÇaid¡£ÏÖÔÚÎÒÏ룬½«ËùÓÐÃûΪaidµÄ×Ö¶ÎÃûÐÞ¸ÄΪbid(×¢Ò⣺ÊÇÐÞ¸Ä×Ö¶ÎÃû)¡£ ÕâÈçºÎʵÏÖ£¬Çó½Ì¸÷λ¸ßÊÖ£¡
µÚÒ»²½£» select TABLE_NAME from information_schema.`COLUMNS` where lower(TABLE_SCHEMA)='capucivar' and lower(COLUMN_NAME)='aid' µÃµ½capucivarÖÐËùÓк¬×Ö¶ÎaidµÄ±íÃû µÚ¶þ²½£º½«Õâ¸öÁÐ±í£¬¸´ÖƵ½£Å£Ø£Ã£Å£Ì±í¸ñÖеģÁÁÐ µÚÈý²½£º£Â£±Ð´È빫ʽ£º="alter table " & A1 & " change aid bid INT;" µÚÈý²½£º¸´ÖÆ£ÂÁУ¬ÌùÈë£Í£Ù£Ó£Ñ£Ì¹¤¾ßÖ´ÐС£ÒýÓà µÚÒ»²½¡¡ ÕâÑùºÃÏñÖ»ÄÜÐ޸ĵÚÒ»¸ö±í°¡¡£ÎÒÏÖÔÚÏëÐ޸ĵÚÒ»²½²éѯ³öÀ´µÄËùÓÐ±í µÚÈý²½£º£Â£±Ð´È빫ʽ£º="alter table " & A1 & " change aid bid INT;" °Ñ£Â£±¸ñµÄ¹«Ê½ÏòÏÂÌí³ä¡£ µÚÈý²½£º¸´ÖÆ£ÂÁУ¬ÌùÈë£Í£Ù£Ó£Ñ£Ì¹¤¾ßÖ´ÐС£ ÍæÊý¾Ý¿âµÄͬѧ£¬Ò»¶¨Òª°Ñ£Å£Ø£Ã£Å£ÌѧºÃ¡£ ½÷Ìý´ó¸ç½Ì»å£¬Ò»¶¨Ñ§ºÃEXCEL¡£µ«ÊÇÓиö´íÎó£¬Âé·³Ò»Æð½â¾öÁ衃 Ìáʾ´íÎóÐÅÏ¢£º #1060 - Duplicate column name 'bid' Ôõô½â¾ö°¡£¬ÄãµÄ±íÖÐÒѾÓÐÁËÒ»¸öbidÁË? Õâ¸öÖ»ÓÐÄã×Ô¼ºÖªµÀÈçºÎ½â¾ö¡£ ллÁË£¡½áÌù
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡ Íò·Ö¸Ðл£¡ String SQL=&q ......
ÈçÌâ¡£ÎÒÒѾ°²×°ÁËmysqlodbcÇý¶¯¡£ adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬ ÓРʹÓÃDataLinkÎļþ ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ ʹÓÃÁ¬½Ó×Ö·û´® ÊÇÑ¡ÔñÄĸö£¿ È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿ HTML code: http://www.connectionst ......