假如有一个表数据结构为 t_user(id,username,password,realname);
使用多条语句批量插入,适用于mysql,sqlserver,oracle
insert into t_user(id,username,password,realname) values('4','jack4','000000','jack4');
insert into t_user(id,username,password,realname) values('5','jack5','000000','jack5');
insert into t_user(id,username,password,realname) values('6','jack6','000000','jack6');
insert into t_user(id,username,password,realname) values('7','jack7','000000','jack7');
缺点:运行速度慢。不推荐使用
1.使用mysql sqlserver 批量插入语句
一条语句执行:
insert into t_user(id,username,password,realname) values
('4','jack4','000000','jack4'),
('5','jack5','000000','jack5'),
('6','jack6','000000','jack6'),
('7','jack7','000000','jack7');
2.上面的语句用于oracle数据库却报错。在oracle数据库中批量插入数据语句
insert all
into t_user(id,username,password,realname) values('4','jack4','000000','jack4')
into t_user(id,username,password,realname) values('5','jack5','000000','jack5')
select 1 from dual;
这样就可以一条语句批量插入数据。