mysql - UPDATE 使用 SELECT 作为 WHERE

Question

我想运行一个更新，其中 WHERE 语句由 2 个 SELECTS 组成，这与您的做法完全接近吗？

UPDATE Requests SET Response=1 WHERE 
sender=SELECT userID FROM Users WHERE Username=?) and 
Reciever = SELECT userID FROM Users WHERE Username=?

谢谢!

Answer 1

你缺少括号，仅此而已。

UPDATE Requests SET Response=1 WHERE 
sender = (SELECT userID FROM Users WHERE Username=?) and 
receiver = (SELECT userID FROM Users WHERE Username=?);