MysqlÖ´ÐÐ.sqlÎļþ
MysqlÓÐûÓÐc/c++ API¿ÉÒÔÖ±½ÓÖ´ÐÐÒ»¸ö.sqlµÄÎļþ£¬¸ÃÎļþÖ÷ÒªÓÃÀ´¸üÐÂÊý¾Ý¿â£¬ÀýÈçÐ޸Ļòн¨±í£¬Ð޸Ļòн¨´æ´¢¹ý³Ì£¡
dosÃüÁîÐУº mysql -uroot -p <xxx.sql ÒýÓà dosÃüÁîÐУº mysql -uroot -p <xxx.sql ÕýÈ·£¬Ö±½ÓÓôӶ¨Ïò¾ÍÐС£ mysql -u root -p dbcu < d:\xxx.sql mysql »¹ÔÃüÁî root Óû§Ãû(root¹ÜÀíÔ±) dbcu ±¸·ÝµÄÊý¾Ý¿âÃû; < »¹Ô·ûºÅ xxx.sql »¹ÔµÄÎļþÃû C¡¡API ÖÐûÓÐÕâÖÖ¹¦ÄÜ¡£ ÄãÖ»ÄÜÔÚCÖдò¿ªÕâ¸öxx.sql Îļþ£¬È»ºóÒ»´ÎÐÔ£¬»ò·ÖÅú½«Óï¾ä¶Á³öÓÃmysql_real_query()Ö´ÐÐ ÔÚmysql>ÏÂÖ´ÐÐsource a.sql¿ÉÒÔÖ´ÐÐ.sqlÖеÄsqlÓï¾ä»òÕßÃüÁî¡£ Äã¿ÉÒÔÓÃc/c++À´µ÷ÓÃÕâ¸öÃüÁî¡£ ÓÃperlÒýÓà ²»Ì«½¨ÒéÔÚCÖÐͨ¹ýµ÷ÓòÙ×÷ϵͳÃüÁîÖеÄmysql ...À´ÊµÏÖÕâ¸ö¹¦ÄÜ¡£ÕâÑùÄãµÄC³ÌÐò¶Ô²Ù×÷ϵͳÒÀÀµÐÔ¹ý¸ß£¨±ÈÈçÄãÐèÒªÖªµÀMYSQL¡£EXEµÄλÖã¬ÐèÒªÁ˽âÊÇUNIX»¹ÊÇWINODWS£© ²»ÈçÖ±½Ófopen ´ò¿ªÎļþºó£¬ÖðÐжÁ³ö£¬Óöµ½; Ôòmysql_real_query() µ«Èç¹û³öÏÖ delimiter // µÈÕâÀàµÄÒª×öÌØÊâ´¦Àí¡£ ÔÙ¼òµ¥Ò»µã¶ù£¬Ö±½Ó¿´Ò»ÉÏmysql.exe µÄÔ´´úÂ룬´ÓÖгһ²¿·ÖËüµÄ source ²¿·ÖµÄ´¦Àí¡£ ËûµÄÔ´´úÂëÔÚÄÄÀï°¡£¿ÒýÓà ËûµÄÔ´´úÂëÔÚÄÄÀï°¡£¿ MYSQL¹ÙÍø¾ÍÓС£ http://dev.mysql.com/downloads/mys
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿ Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ..... ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡ ½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â 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: ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......