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×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂ𣿠Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡ ²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÔÚubuntuÏ´îÅäÀïphp»·¾³£¬¿ÉÊÇÀïÃæµÄ±àÂëÎÊÌâ¿ì°ÑÎұƷèÁË¡£ Ï£Íû¸ßÊÖÄܰïÎÒ½â¾ö¡£Ð»ÁË¡£¡£¡£ ÎÒµÄmysql×Ö·ûÉèÖÃÈçÏ£º mysql> show variables like 'character%'; +--------------------------+--------- ......