mysql - 两个 WHERE 子句

Question

我正在尝试执行类似以下查询的操作:

UPDATE `race_records` SET vehicle = SELECT name FROM vehicles WHERE model_id = 567 WHERE playerid = 3    

但显然这是不正确的并且不起作用。

我想将 vehicles 中的字符串插入到 race_records 的一行中，其中playerid = 3。

Answer 1

使用AND？

UPDATE `race_records` 
SET vehicle = (SELECT name FROM vehicles
               WHERE model_id = 567 AND playerid = 3)

或者您希望内部查询中有一个 WHERE，而外部查询中有一个 WHERE，在本例中:

UPDATE `race_records` 
SET vehicle = (SELECT name FROM vehicles
               WHERE model_id = 567)
WHERE playerid = 3