mysql中批量往表里插入数据,比如有十条语句:
insert into tab1(1,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(2,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(3,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(4,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(5,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(6,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(7,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(8,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(9,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(10,'a','mmmmmmmmmmmmmmmmm');
我想一次批量执行,并且当某条语句出错,就回滚。
不用存储过程的话该怎么写??
insert into tab1 values(
(1,'a','mmmmmmmmmmmmmmmmm'),
(2,'a','mmmmmmmmmmmmmmmmm'),
(3,'a','mmmmmmmmmmmmmmmmm'),
(4,'a','mmmmmmmmmmmmmmmmm'),
(5,'a','mmmmmmmmmmmmmmmmm'),
(6,'a','mmmmmmmmmmmmmmmmm'),
(7,'a','mmmmmmmmmmmmmmmmm'),
(8,'a','mmmmmmmmmmmmmmmmm'),
(9,'a','mmmmmmmmmmmmmmmmm'),
(10,'a','mmmmmmmmmmmmmmmmm')
);
#f:\\MySQL\\tab1.sql为tab1.sql所在的路径,可以先用记事本编写tab1.sql放在f:\\MyS
我以前安装了一次,后来卸载了,现在再安装的时候,提示错误:Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
可是我找 ......