insert into table_a(field_a1,field_a2,field_a3) select field_b1,field_b2,field_b3 from table_b
实例:
insert into biz_dict(id,BIZ_TYPE,biz_value,biz_desc) select t1.id,t1.data_dictionary_type,t1.data_dictionary_value,t1.data_dictionary_desc from data_dictionary t1 where t1.data_dictionary_type='省份'