一、插入部分表数据,示列:将table_name_new表中五个字段对应插入到table_name表中,where后面是条件判断可去掉(where forgid = '0',插入指定行数据)
insert into table_name t (t.val1,t.val2,t.val3,t.val4,t.val5,t.val6,t.val7,t.val8,t.val9,t.val10,t.val11...)
select c.val1,c.val2,'xx','xx',c.val3,c.val4,'xx','xx','xx','xx',c.val5... from table_name_new c where c.val1 is not null;
二、全部插入表数据,table_name与table_name_new表结构需要一样
insert into table_name (select t.val1,t.val2,t.val3... from tabel_name_new t)
三、简单插入表数据
insert into table_name values(val1,val2,val3,val4....)
insert into table_name t (t.val1,t.val2,t.val3...) values (val1,val2,val3...)