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

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


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sql server - Java / Eclipse

Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....

ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡

½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......

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Êý¾Ý¿â - Java / 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 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ