我在命令中心里一次输入两条以上insert语句
insert into newuser(username,password,email) values('Amy','1234','Amy@ss.com')
insert into newuser(username,password,email) values('Judy','1234','Judy@ss.com')
就会出错,而分开一条条的来,就没问题,还有这事?
...全文
2977打赏收藏
DB2不能一次插入多条记录么??
我在命令中心里一次输入两条以上insert语句 insert into newuser(username,password,email) values('Amy','1234','Amy@ss.com') insert into newuser(username,password,email) values('Judy','1234','Judy@ss.com') 就会出错,而分开一条条的来,就没问题,还有这事?
可以写一个脚本
db2 connect to yourdb user yourname using yourpassword
db2 insert into newuser(username,password,email) values('Amy','1234','Amy@ss.com')
db2 insert into newuser(username,password,email) values('Judy','1234','Judy@ss.com')
db2 commit
db2 disconnect yourdb