方法一:
insert into table1 values(), (), ()
insert into table1(columns) values(), (), ()
方法二:
insert into table1 select * from table2
insert into table1(columns) select columns from table2
如何使用insert into语句批量插入数据?
最新推荐文章于 2024-07-03 13:27:00 发布
方法一:
insert into table1 values(), (), ()
insert into table1(columns) values(), (), ()
方法二:
insert into table1 select * from table2
insert into table1(columns) select columns from table2