大致意思 是 不能先将select出表中的某些值,再update这个表(在同一语句中)
可以引入一个临时表进行操作
delete from push_plans WHERE id in
(
select id from
(
select id from push_plans WHERE area_id = 0
) as t
)
大致意思 是 不能先将select出表中的某些值,再update这个表(在同一语句中)
可以引入一个临时表进行操作
delete from push_plans WHERE id in
(
select id from
(
select id from push_plans WHERE area_id = 0
) as t
)