mysql用中间表,加索引,从一张表中特定字段内容导入另一张表特定字段内容

表a:edu_app_school_info(字段area_id)
--------表b:edu_app_xq_school_class(字段area_id)
匹配字段
表a: xq_id
表b: school_id
表a:数据量6000条
表b:数据量十万条

1. 创建中间表
   create table xq_area (
   area_id varchar (192),
   xq_id varchar (90)
   );
2. 共同匹配字段添加索引
   alter table xq_area add index index_name(xq_id);
3. 向中间表插入数据
   insert into xq_area(area_id,xq_id) select area_id,xq_id from edu_app_school_info group by area_id,xq_id;
4. 将中间表对应字段更新到目标表
   UPDATE edu_app_xq_school_class,xq_area SET edu_app_xq_school_class.area_id=xq_area.area_id WHERE edu_app_xq_school_class.school_id = xq_area.xq_id;