根据查询结果更新
update select 语句(注意:必须使用inner join)
采用的格式为:
update table_a inner join( select xx,a_id frrom table_b ) as b on table_a .id = b.a_id set table_a.xx = b.xx;
eg:
update sys_lang inner join (select l_id as vc_id, level,vc_area_name from d_area) as b on sys_lang.vc_code = b.vc_area_name set sys_lang.level = b.level,sys_lang.vc_id = b.vc_id;