db2一次插入多条数据
怎么在db2中 插入多条数据？
表结构为 create table t(id int,name varchar(255));
[解决办法]
insert into t(id,name)
select * from (
select 1,'Jimmy' from sysibm.sysdummy1 fetch first 1 row only
union all select 2,'Connie' from sysibm.sysdummy1 fetch first 1 row only
) A
[解决办法]
insert into t(id, name) values
(1, 'A'),
(2, 'B'),
(3, 'C')
;
