数据库批量插入【数据库】

//Oracle批量插入 dual为系统参数
insert into Test(name,Value)
select '1','1'
from dual
union all
select '2','2'
from dual
union all
select '3','3'
from dual
union all
select '3','3'from dual

SQL server批量插入

insert into ys (Name,Value) values
('1','1'),
('2','2'),
('2','2'),
('3','3'),
('4','4')