在实际应用中,有可能会用到,从别的表查询(或关联查询)出结果,并且插入到另一张表中。
简单的
INSERT INTO table1(field1,field2,field3,field4,field5)
select field1,field2,field3,field4,field5 from table2
where -- 写查询条件
多表关联
INSERT INTO table1(field1,field2,field3,field4,field5)
select a.field1,a.field2,a.field3,b.field4,b.field5 from table2 as a
left join table3 as b on a.filed = b.filed
where -- 写条件