MySQL批處理SQL語句

標籤：檔案   資料   art   for   re   c   div   ar   

MySQL 支援批處理的模式運行一批SQL語句，以下的範例就是實驗MySQL怎樣在windows下批處理運行SQL語句。

create table test(id int,name varchar(20));
insert into test values(1,‘watson‘);

 

batchfile.txt裡包括以下的一些SQL 陳述式，此檔案放在windows系統的c:/batchmysql/batchfile.txt

insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;
insert into test select * from test;

 

在cddl資料庫裡進行批運行上面的語句例如以下：
mysql -uroot -p -D cddl < c:/batchmysql/batchfile.txt

 

以下是把批處理裡含有查詢的資訊，輸出儲存到一個檔案中：

此時的batchfile2.txt裡含有query的資訊(以下的3條SQL語句)，以下的mysql0716.out就記錄了select * from test limit 200;查詢語句的結果集。
select * from test limit 200;
insert into test select * from test;
insert into test select * from test;

You can catch the output in a file for further processing:
mysql -uroot -p -D cddl < c:/batchmysql/batchfile2.txt >c:/batchmysql/mysql0716.out