insert into b(a, b, c) select d,e,f from a;

-- delete from date_record_copy;

insert into date_record_copy(year, month, amount) select year, month, amount from date_record;

4. 说明：拷贝表( 拷贝数据, 源表名：a 目标表名：b)

SQL: insert into b(a, b, c) select d,e,f from a;