SQL查询语法错误

Question

我在此查询中遇到语法错误，但我不知道我做错了什么。

UPDATE `jos_planning2_rosters` r
LEFT JOIN jos_planning2_rosters_setup s ON r.id = s.roster_id
LEFT JOIN jos_planning2_workplaces w ON s.workplace_id = w.id
WHERE r.roster_state =1
AND s.card_id IS NULL
AND s.type_id = '2'
AND r.roster_date >= DATE( NOW()) SET s.card_id = '1', s.type_id = '1' 
WHERE s.type_id = '2', s.card_id IS NULL, r.id = '8';

Answer 1

您的查询中有两个 WHERE 子句。

Answer 2

您是否尝试这样做，查询一团糟：

UPDATE s
SET    s.card_id = '1', 
       s.type_id = '1'
From   jos_planning2_rosters_setup s
       INNER JOIN jos_planning2_rosters r ON r.id = s.roster_id
WHERE  r.roster_state = 1
       AND s.card_id IS NULL
       AND s.type_id = '2'
       AND r.roster_date >= GetDate()
       AND r.id = '8';

Answer 3

尝试一下，不要在 jos_planning2_rosters 周围添加反引号。