UPDATE t_flight_real_time r
INNER JOIN t_flight_real_time_total t ON r.flight_seq = t.flight_seq
SET r.order_no = t.task_id
WHERE
r.uav_id = t.uav_id
AND r.order_no != t.task_id
转载于:https://my.oschina.net/u/1763091/blog/3062184
UPDATE t_flight_real_time r
INNER JOIN t_flight_real_time_total t ON r.flight_seq = t.flight_seq
SET r.order_no = t.task_id
WHERE
r.uav_id = t.uav_id
AND r.order_no != t.task_id
转载于:https://my.oschina.net/u/1763091/blog/3062184