将某个表的某些字段插入到另一个表中
insert into test2 b
select '2020' ,
plancode ,
sa ,
prem ,
gender ,
bt ,
pt ,
age ,
dt ,
div from test1 a where year='2019';
insert into test2 b
select '2020' ,
plancode ,
sa ,
prem ,
gender ,
bt ,
pt ,
age ,
dt ,
div from test1 a where year='2019';