把一个表数据插入到另一张表
insert into tableB (field1,field2,field3,field4) select field1,field2,field3,'val4' from tableA where field1='val1'
把一个表数据插入到另一张表
insert into tableB (field1,field2,field3,field4) select field1,field2,field3,'val4' from tableA where field1='val1'