在前面的章節(jié)中，你交互式地使用mysql輸入查詢并且查看結(jié)果。你也可以以批模式運(yùn)行mysql。為了做到這些，把你想要運(yùn)行的命令放在一個(gè)文件中，然后告訴mysql從文件讀取它的輸入：

source filename;

如果在Windows下在命令行上指定連接參數(shù)，命令應(yīng)為：

C:\Users\Administrator>mysql -h localhost -u root -p123456 test -e "source E:/batch.txt"
Enter password: ********

在E盤下新建batch.TXT,里面寫入SQL

select * from pet;
select * from pet where name like '%b%';

調(diào)用腳本

mysql> source E:/batch.txt(或者 \. E:/batch.txt)
+----------+-------+---------+------+------------+-------+
| name     | owner | species | sex  | birth      | death |
+----------+-------+---------+------+------------+-------+
| Whistler | Gwen  | bird    | NULL | 1997-12-09 | NULL  |
| Puffball | Diane | hamster | f    | 1999-03-30 | NULL  |
+----------+-------+---------+------+------------+-------+
2 rows in set (0.00 sec)

+----------+-------+---------+------+------------+-------+
| name     | owner | species | sex  | birth      | death |
+----------+-------+---------+------+------------+-------+
| Puffball | Diane | hamster | f    | 1999-03-30 | NULL  |
+----------+-------+---------+------+------------+-------+
1 row in set (0.00 sec)