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