mysql - 错误 1093 Mysql

Question

Hello , when I try this:

 UPDATE SET managedBy_id=(SELECT id FROM users  as managedBy_id WHERE login=123456) WHERE login=72584; 

The output is: Error Code: 1093. You can't specify target table 'users' for update in FROM clause 0.000 sec

Answer 1

您的UPDATE语句错误，请修改为

UPDATE users 
SET managedBy_id = CASE WHEN login=123456 THEN id ELSE managedBy_id END
WHERE login=72584;