Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÁË?
Õâ¸öÖ»ÓÐÄã×Ô¼ºÖªµÀÈçºÎ½â¾ö¡£

ллÁË£¡½áÌù


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

ÔõôÔÚeclipseÏÂÏòmysql²åÈë±äÁ¿°¡ - Java / JavaÏà¹Ø

String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡­¡­µ½µ×¸Ãզд°¡

Íò·Ö¸Ðл£¡

String SQL=&q ......

ÇëÎÊʹÓÃado¿Ø¼þÁ¬½ÓmysqlÊý¾Ý¿âµÄ²½ÖèÊÇʲô

ÈçÌâ¡£ÎÒÒѾ­°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ