具体场景：将一张表的某一列的数据同步到另一张表的某一列

2019独角兽企业重金招聘Python工程师标准>>>

问题：点抄表看不到抄表信息，原因是仪表找不到，将新的merter_id换回旧的merter_id
#问题抄表单
select * from t_work_order where number in ('GD2017113000228');

#作业表t_work_order.task_plan_id
select * from t_task_plan where task_plan_id=1358;
#关联表
select * from t_task_plan_meter_related where task_plan_id=1358;
#旧merter_id备份
select a.meter_id ,b.meter_id as old_id from t_meter a,
(
select * from t_meter_copy1202 where meter_id in (select meter_id from t_task_plan_meter_related where task_plan_id=1358)
)b
where a.ets_id=b.ets_id;

#执行仪表更新操作
update t_task_plan_meter_related s, 
(select a.meter_id ,b.meter_id as old_id from t_meter a,
(
select * from t_meter_copy1202 where meter_id in (select meter_id from t_task_plan_meter_related where task_plan_id=1358)
)b
where a.ets_id=b.ets_id) c
   set s.meter_id = c.meter_id
 where s.meter_id = c.old_id
and s.task_plan_id=1358
 

转载于:https://my.oschina.net/liuruibin/blog/1590216