mysql - 使用多个 JOIN 执行 MySQL UPDATE

Question

我有以下有效的查询...

SELECT u.route_id, g.route_id
FROM user_route u
JOIN user_address a ON a.address_id = u.route_begin_id
JOIN user_address b ON b.address_id = u.route_finish_id
JOIN google_route g ON g.route_begin_id = a.address_google_id 
AND g.route_finish_id = b.address_google_id

但我想用 g.route_id 的值更新 u.google_route_id

谁能建议我如何解决这个问题，谢谢。

Answer 1

update user_route u
JOIN user_address a ON a.address_id = u.route_begin_id
JOIN user_address b ON b.address_id = u.route_finish_id
JOIN google_route g ON g.route_begin_id = a.address_google_id 
AND g.route_finish_id = b.address_google_id)
set u.google_route_id=g.route_id