Oracle中:
insert into product
(id,names, price, code)
select 100,'a',1,1 from dual
union
select 101,'b',2,2 from dual;
insert into product
(id,names, price, code)
select 100,'a',1,1 from dual
union
select 101,'b',2,2 from dual;
这里最好用一次insert,不然效率不高,用多个select.
这样就可以插入多条数据