mysqlÊý¾Ýµ¼ÈëÎÊÌâ
±ÈÈç°ÑÒ»¸ö.txtÎļþµÄÄÚÈݵ¼Èëµ½mysqlÊý¾Ý¿âµÄÀïÃæµÄtxstÊý¾Ý¿âÀïÃæ£¬£¬Ò³Ãæ±àÂëµÄºÍÊý¾Ý¿âÀïÃæ¶¼ÊDzÉÓÃutf-8½øÐбàÂ루ÏîÄ¿±ØÐë²ÉÓÃutf-8±àÂ룩£¬µ«µ¼Èëµ½Êý¾Ý¿âÀïÃæÖÐÎÄÊÇÂÒÂ룬µ«µ¼Èë³öÀ´¿ÉÒÔÏÔʾÖÐÎÄ£¬£¬ÇëÎÊÔõô½â¾ö°¡ £¬£¬ ÓÃgb2312ºÍÉÏÃæµÄÇé¿öÒ²ÊÇÒ»Ñù£¨µ«ÓÖ²»ÄÜÓÃGB2312£© ÄÄλ´ó¸ç˵Ï£¬£¬Ð¡µÜ¸Ð¼¤²»¾¡
¶÷ ÄãµÄÊÇlinuxϵͳ»¹ÊÇWINµÄ£¿ ¸øÄ㼸¸öÃüÁî°É£¡ Perl code: //ÏȽøÈëµ½ÄãµçÄÔµÄDÅÌ D:\>cd AppServ\MySQL\bin D:\AppServ\MySQL\bin\>mysql -u root -p Enter password:123 //Õâ¸öÊÇÃÜÂë mysql>use Êý¾Ý¿âÃû mysql>source d:\wcnc_db.sql//ÐèÒªµ¼ÈëÊý¾Ý¿âµÄ·¾¶ winÒýÓà ¶÷ ÄãµÄÊÇlinuxϵͳ»¹ÊÇWINµÄ£¿ WIN ÎÒ¸øÁËÄãDOS ÃüÁîÁË ÓÃÁËû£¿¿ÉÒÔ°É£¿ ºÃÏñ»¹ÊDz»Ðа¡
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£ ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......