批量新增查询到的结果集 INSERT INTO SELECT

最新推荐文章于 2023-11-08 21:57:23 发布

iteye_7824

最新推荐文章于 2023-11-08 21:57:23 发布

阅读量1.1k

点赞数

分类专栏： SQL 文章标签： MySQL SQL

本文链接：https://blog.csdn.net/iteye_7824/article/details/81900029

版权

SQL 专栏收录该内容

1 篇文章

订阅专栏

基本语法：


INSERT INTO "表格1" ("栏位1", "栏位2", ...)
SELECT "栏位3", "栏位4", ...
FROM "表格2"

db是mysql，由于id是auto_increment的实例：


inset into t_split_aa(batchId,contractId,clientId,type,year,month,date,amount,totalPrice,totalHours,unitPrice,note,days,signDate,cancelDate,firstDate,legalId,freezenDays)
select batchId,contractId,clientId,type,year,month,date,amount,totalPrice,totalHours,unitPrice,note,days,signDate,cancelDate,firstDate,legalId,freezenDays from t_split_a order by id