Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾äÁË£¬¶àÓàÁË

ÔõôºÃÏñûÆð×÷ÓÃÄØ¡£ÎÒÖ´ÐÐÁËһϣ¬ÖÐ;ͣµô£¬È´Ã»Óлعö¡£¡£¡£ÊÇÔõô»ØÊÂÄØ£¿


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

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

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

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

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

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

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

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

mysqlÂÒÂëÎÊÌâ

ÎÒÔÚubuntuÏ´îÅäÀïphp»·¾³£¬¿ÉÊÇÀïÃæµÄ±àÂëÎÊÌâ¿ì°ÑÎұƷèÁË¡£
Ï£Íû¸ßÊÖÄܰïÎÒ½â¾ö¡£Ð»ÁË¡£¡£¡£
ÎÒµÄmysql×Ö·ûÉèÖÃÈçÏ£º
mysql> show variables like 'character%';
+--------------------------+--------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ