update gt_mission a -- 必须使用别名
set time_scale0=(select b.time_scale from (select distinct mission_id,time_scale from gt_query_mission) b where b.mission_id=a.guid)
where exists (select 1
from gt_query_mission b where b.mission_id=a.guid) ;
set time_scale0=(select b.time_scale from (select distinct mission_id,time_scale from gt_query_mission) b where b.mission_id=a.guid)
where exists (select 1
from gt_query_mission b where b.mission_id=a.guid) ;