mysql - 我正在尝试使用 join with update 查询但找不到问题

Question

请帮我改正语法

UPDATE
    user_shift_test
SET
    shifttime='01:00-21:00'
FROM
    user_shift_test
INNER JOIN swaps 
ON 
    user_shift_test.userid=swaps.csrid 
WHERE
    user_shift_test.userid=5

出现这个错误

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM user_shift_test INNER JOIN swaps ON user_shift_test.useri' at line 5

Answer 1

UPDATE user_shift_test
SET shifttime='01:00-21:00'
WHERE userid IN 
               (SELECT user_shift_test.userid
                FROM user_shift_test
                JOIN swaps ON swaps.csrid=user_shift_test.userid
                WHERE 
                user_shift_test.userid=5
               );