当前位置:Gxlcms > mysql > Oracle插入多条记录的sql

Oracle插入多条记录的sql

时间:2021-07-01 10:21:17 帮助过:4人阅读

插入多条记录的sql语句--Oracle insert into db(id, zgbh, shbzh) select

insert
into db(id, zgbh, shbzh)
select '1', '2', '3' from dual
union all select '2', '3', '4' from dual
union all select '3', '4', '5' from dual
union all select '4', '5', '6' from dual
union all select '5', '6', '7' from dual

人气教程排行