MySQL批处理

学习和复习MySQL时，常有大量重复动作，尤其创建工作表等，使用批处理可以方便不少。

举例如下。假设环境参数已设置，MySQL测试账号：root，密码：123456。工作目录：C:\SQL\MySQL。输入：create-products_tbl.bat，create-products_tbl.bat。结果输出：sql.out。

注意：需用管理员权限运行create-products_tbl.bat。

输入：

create-products_tbl.bat文件：

@echo off
rem reference: http://www.cnblogs.com/allenblogs/archive/2011/08/22/2149716.html

rem this bat file path
cd C:\SQL\MySQL

net start mysql

mysql -h localhost -uroot -p123456 < create-products_tbl.sql > sql.out

net stop mysql

pause

create-products_tbl.sql文件：

# select database
use mysql

# create products_tbl
drop table if exists products_tbl;
create table products_tbl (prod_id varchar(10) not null primary key, prod_desc varchar(25) not null, cost float(6,2) not null);
insert into products_tbl values('11235','witch costume',29.99);
insert into products_tbl values('222','plastic pumpkin 18 inch',7.75);
insert into products_tbl values('13','false paraffin teeth',1.1);
insert into products_tbl values('90','lighted lanterns',14.5);
insert into products_tbl values('15','assorted costumes',10);
insert into products_tbl values('9','candy corn',1.35);
insert into products_tbl values('6','pumpkin candy',1.45);
insert into products_tbl values('87','plastic spiders',1.05);
insert into products_tbl values('119','assorted masks',4.95);

# select command
select * from products_tbl where cost>7 and length(prod_desc)>13;

exit

sql.out文件：

prod_id prod_desccost
15 assorted costumes10
222 plastic pumpkin 18 inch7.75
90 lighted lanterns14.5

参考资料：http://www.cnblogs.com/allenblogs/archive/2011/08/22/2149716.html