mysqlÊÂÎñÇë½Ì
ÎÒÕâÓиöµ¼ÈësqlÎļþµÄÅú´¦Àí£º SQL code: set path="C:\Program Files\MySQL\MySQL Server 5.4\bin" @ECHO ON ECHO ½øÈëMysqlĿ¼.... ECHO ECHO Êý¾Ý¿âÕýÔÚÖ´ÐÐÖÐ.... mysql -uroot -p -D -t nxjsw_hope<d:\datas\expDatas.sql ECHO µ¼ÈëÖ´ÐÐÍê±Ï ECHO. pause exit ÓÉÓÚÒªµ¼ÈëµÄÎļþÈ«ÊÇinsertÓï¾ä£¬ÎļþÒ²ÊÇ´Ó¿âÀï×Ô¶¯µ¼³öµÄ£¬×î¶àµÄÓÐÉÏÃæÍòÌõ¼Ç¼£¬µ«ÊÇmysqlÓÐ×Ô¶¯Ìá½»£¬Çë½Ì¿´µ½µ½¸ßÊÖÃÇ£¬ÎÒÔõô¿ÉÒÔÔÚÕâ¸öÅú´¦ÀíÖмÓÈëÊÂÎñ´¦Àí£¬ÎÒ¼ÓÁ˺󣬸ù±¾¾Í²»ÈÏbeginµÄÊÂÎñ¹Ø¼ü×Ö£¬
Óà SQL code: START TRANSACTION; --¿ªÆôÊÂÎñ insert .. insert .. insert .. COMMIT or ROLLBACK [ ÕâÑù²»ÐУ¬ÎÒÕâ¸öÅú´¦ÀíÊǸøÓû§Óõ쬣¬£¬ËùÒÔµ¼³öÀ´µÄµÄsqlÎļþÊÇÓÉÓû§À´²Ù×÷µÄ¡£¡£ ËùÒÔÓÐûÓа취ÔÚÅú´¦Àí¼ÓÕâ¸öÊÂÎñÒýÓà ECHO Êý¾Ý¿âÕýÔÚÖ´ÐÐÖÐ.... mysql -uroot -p -D -t nxjsw_hope -e "set @@autocommit=0; START TRANSACTION;source d:/datas/expDatas.sql; commit;" ECHO µ¼ÈëÖ´ÐÐÍê±Ï ÓÐstart transaction, ¾Í²»ÒªÔÙ¼Óset @@autocommitÓï¾äÁË£¬¶àÓàÁË ÔõôºÃÏñûÆð×÷ÓÃÄØ¡£ÎÒÖ´ÐÐÁËһϣ¬ÖÐ;ͣµô£¬È´Ã»Óлعö¡£¡£¡£ÊÇÔõô»ØÊÂÄØ£¿
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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Êý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8 ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÔÌûÇë¿´ http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601 ×ܽáϾÍÊÇ apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......