SQL一次性插入多条记录
SQL的批量插入MYSQL
如:
insert into book(id, name) values (1, '冰与火之歌'),(2, '动物庄园')
insert into book(id,name) select 1, '冰与火之歌' from dual union select 2, '动物庄园' from dual
insert into book(id, name) select seq.nextval, name from (select '冰与火之歌' as name from dual union select '动物庄园' as name from dual)