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

mysqlµÄÒ»µãСÎÊÌâ

×òÌìÓÃload data infile Ïò±íÀïÃæµ¼Êý¾ÝµÄʱºò,µ¼µ½Ò»°ëͻȻ±¨data too long for columnÕâÑùµÄ´íÎó,µ½ÍøÉÏÒ»²é,ÍøÉÏ´ó¶à˵ÊÇ×Ö¶Î×Ö·û±àÂëÎÊÌâ,Èç¹ûÊDZàÂëÎÊÌâÓ¦¸ÃÒ»ÌõÊý¾ÝÒ²µ¼²»Á˵Äѽ.ºóÀ´°Ñ±íµÄÒýÇæ¸Ä³Émyisamºó,ÔÙµ¼,·¢ÏÖ¿ÉÒÔµ¼Èë³É¹¦,°Ñ±íÒýÇæ»»³Éinnodbºó,ÓÖ±¨data too long for column µÄ´íÎó,ÄÄλ´óϺ¿ÉÒÔ°ïæ½âÊÍÒ»ÏÂÂð?
¹Ø×¢£¡

ûÓдóÏÀÏà¾Èѽ

µ½mysql°æÈ¥ÎÊÎʰɣ¡

ȷʵӦ¸ÃÊDZàÂë¸ñʽÎÊÌâ°¡£¬ÄãÒªµ¼ÈëµÄÎļþµÄ±àÂë¸ñʽ±ØÐëºÍmysqlµÄ±àÂë¸ñʽͳһ£¬²»È»¿Ï¶¨ÊDz»Ðеģ¡

ÒýÓÃ
ȷʵӦ¸ÃÊDZàÂë¸ñʽÎÊÌâ°¡£¬ÄãÒªµ¼ÈëµÄÎļþµÄ±àÂë¸ñʽ±ØÐëºÍmysqlµÄ±àÂë¸ñʽͳһ£¬²»È»¿Ï¶¨ÊDz»Ðеģ¡


±àÂëÓ¦¸ÃÊÇÒ»ÖµÄ,¶¼ÊÇ´ÓÁíÒ»¸ö¿âÖе¼³öÀ´µÄ,ÒªÊDZàÂë²»¶ÔµÄ»°,Ó¦¸Ãµ¼µÚÒ»Ìõ¾Í²»³É¹¦Ñ½

ÄãÈ¥SQL °æ È¥ÎÊÎÊ£¡ÄDZ߸ßÊֺܶ࣡

È¥ÁË,ÄDZߺÃÀäÇåµÄ

ÊǸñʽÓÐÎÊÌâ

Ó¦¸ÃÊÇÊý¾ÝÀàÐ͵ÄÎÊÌâ¡£

ÄãÈ¥MSSQL°æÑ½£¡ MYSQL°æÈ˺ÜÉÙµÄ! ÎÒÒÔǰ¾ÍÊÇ»ìMSSQL°æµÄ ÀïÃæÒ²ÓÐMYSQL¸ßÊÖ£¡ Ö±½ÓÎÊÒ»¸ö½Ðʯͷ¸çµÄ£¡

ÏÈÏë°ì·¨È·¶¨Ô­Òò£¡

°ÑÄãµÄÎļþÖð½¥ËõС£¬ÕÒµ½³ö´íµÄÄÇÒ»ÐС£

Èç¹ûÊÇijһÐÐ´í£¬ÔòÊÇÊý¾ÝºÍ±í½á¹¹ÉϵÄÔ­Òò¡£
Èç¹ûÊÇÿÐж¼²»ÐУ¬ÔòÊÇ×Ö·û¼¯ÉϵÄÔ­Òò¡£

¹À¼ÆÊǸñʽµÄÎÊÌâ

ÐÞ¸ÄÏÂmysqlµÄģʽ£¬baiduϾÍÓкܶà´ð°¸µÄ

Õâ¸öÎÊÌâºÃÏñǰ¼¸ÌìÓÐÈËÎʹý£¬Èç¹ûÊÇ1406´íÎóµÄ»°£¬¿ÉÒԲο¼Õâ¸öÌû×Ó£ºhttp://topic.csdn.net/u/20091025/22/541aa1fb-b149-44b2-9c04-34e19b56f313.html

ÊDz»ÊÇÄãдµÄ×Ö¶ÎÃûÌ«³¤À²£¿


Ïà¹ØÎÊ´ð£º

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

MYSQLÓëSmartyµÄÓ¦ÓÃ

ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
£¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......

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

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

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

Äã¾ÍÕâ½ÓÔÚҳà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ