mysql - 基于 3 个表更新

Question

我尝试同时更新 3 个表。 clients.id > cars.client_id > works.car_id 不显示

UPDATE clients, cars, works 
JOIN cars on cars.client_id = clients.id 
JOIN works on works.car_id = cars.id 
SET clients.name = '15-adsadadadsa' , 
clients.email = '15-aaa@aa.com' , 
clients.phone = '15-3232131', 
clients.email = '15-aaa@aa.com' , 
cars.reg = 'aaa-aaa' , 
cars.model = 'aaa-aaa' , 
cars.year = '111111' , works.work = 'aaaa' WHERE works.id = '15';

但是报错

不是唯一的表/别名:'cars'

谢谢你的帮助!

Answer 1

那是因为 cars 表被提到了两次(在 UPDATE 和 JOIN 中)，你不需要提到表名在 UPDATE 中，如果它们在 JOIN 中，试试这个:

UPDATE clients
JOIN cars on cars.client_id = clients.id 
JOIN works on works.car_id = cars.id 
SET clients.name = '15-adsadadadsa' , 
clients.email = '15-aaa@aa.com' , 
clients.phone = '15-3232131', 
clients.email = '15-aaa@aa.com' , 
cars.reg = 'aaa-aaa' , 
cars.model = 'aaa-aaa' , 
cars.year = '111111' , works.work = 'aaaa' WHERE works.id = '15';