更新查询条件来自要更新表的sql语句
UPDATE user_calendarSET
special_attention = 0
WHERE
id IN (SELECT
a.id
FROM
user_calendar a
WHERE
a.user_id = 4 AND a.status = 0 AND a.special_attention =0)上面不行
按下面写法UPDATE user_calendar
SET
special_attention = 0
WHERE
id IN (SELECT
temp.id
FROM
(SELECT
a.id
FROM
user_calendar a
WHERE
a.user_id = 4 AND a.status = 0 AND a.special_attention =0) temp) 要这样写
页:
[1]