一句insert语句插入多行数据可以提高写入的效率
mysql语法:
insert into table(a,b,c) values(a1,b1,c1),(a2,b2,c2),……
oracle语法:
insert into table(a,b,c)
select a1,b1,c1 from dual
union all
select a2,b2,c2 from dual
union all
select a3,b3,c3 from dual
……
mysql语法:
insert into table(a,b,c) values(a1,b1,c1),(a2,b2,c2),……
oracle语法:
insert into table(a,b,c)
select a1,b1,c1 from dual
union all
select a2,b2,c2 from dual
union all
select a3,b3,c3 from dual
……