数据库中如何实现批量插入
批量插入操作
Sql批量插入的语法
insert into user_p(id,name) values(1,"tom"),(2,"lucy"),(3,"jerry")
Oracle中批量插入的语法
insert into role_user_p(user_id,role_id)
(select 1,11 from dual) union all
(select 2,22 from dual)
数据库中如何实现批量插入
批量插入操作
Sql批量插入的语法
insert into user_p(id,name) values(1,"tom"),(2,"lucy"),(3,"jerry")
Oracle中批量插入的语法
insert into role_user_p(user_id,role_id)
(select 1,11 from dual) union all
(select 2,22 from dual)