将表2的数据插入到表1
语法:
insert into 表1(插入字段)select 插入字段 from 表2 where ...
实战例子:
INSERT INTO 表1 (syncid,syncdes,tablename,keyfields,syncfields,version,serialno)
select syncid,syncdes,tablename,keyfields,syncfields,version,serialno from 表2 where syncid=#{syncid}