正确语句:
update A set `status` = 0 where activityId in (
select b.activityId from ( select activityId from A where date_sub(startTime,interval -1 day) <= date_sub(NOW(),interval 0 day) ) as b
错误语句
update A set `status` = 0 where activityId in (
select activityId from A where date_sub(startTime,interval -1 day) <= date_sub(NOW(),interval 0 day) )