mysql在执行下面这段sql会爆出错误提示
update wk_order set wod_state =4 where id in
(select id from wk_order where time >'2022-05-01')
它的意思大概指不能根据 查出来的数据再去修改同一张表的数据。
解决办法:可以通过子查询规避这个问题
update wk_order set wod_state =4 where id in
(select k.id from (select id from wk_order where time >'2022-05-01') k)