Mysql 一个表中的规定字段导入另外一个表中的对应的字段

表2的数据导入表1
INSERT INTO 表1 (name_add, longitude, latitude, province, town, types, address, area, province_code, time_tamp, town_code, area_code, location) SELECT name_add, longitude, latitude, province, town, types, address, area, province_code, time_tamp, town_code, area_code, location FROM 表2;