本文介绍了如何在Windows和Ubuntu环境下使用MySQL进行批处理，包括创建表、插入数据以及从批处理文件执行SQL语句。示例展示了如何将SQL语句写入文件并用mysql命令行工具执行，以及如何捕获查询输出并保存到文件。
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;
在cdd
最低0.47元/天 解锁文章
2330
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
