在前面的章節(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)
