MySQL 支持批處理的模式運(yùn)行一批SQL語句，以下的樣例就是實(shí)驗(yàn)MySQL怎樣在windows下批處理運(yùn)行SQL語句。

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

?

batchfile.txt里包括以下的一些SQL 語句，此文件放在windows系統(tǒng)的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數(shù)據(jù)庫里進(jìn)行批運(yùn)行上面的語句例如以下：
mysql -uroot -p -D cddl < c:/batchmysql/batchfile.txt

?

以下是把批處理里含有查詢的信息，輸出保存到一個(gè)文件中：

此時(shí)的batchfile2.txt里含有query的信息(以下的3條SQL語句)，以下的mysql0716.out就記錄了select * from test limit 200;查詢語句的結(jié)果集。
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