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

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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ÖÐÎÄÂÒÂë - C/C++ / C++ ÓïÑÔ

mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......

ÎÊÒ»¸ö×Ö·û¼¯µÄÎÊÌ⣬´Ómysql°æÀ´

Ô­ÌûÇë¿´
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 - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ