语法:
targetTable ===数据入库的表
sourceTable===数据来源表
格式:
INSERT INTO targetTable
( SELECT * FROM sourceTable WHERE condition)
实例:
insert into company (ID,FULLNAME)
(select acb.comId as ID,acb.displayName as FULLNAME from old_company acb where acb.GROUP_CODE='1')