Mysql中不能update自身的解决方法

今天介绍一下Mysql中不能update自身的解决方法：

问题：

无法执行:

update bi_data.order_all_detail
set err_msg='同时存在于wx,zfb平台',proc_time=now()
where order_no in
(
select order_no
from bi_data.order_all_detail
group by order_no
having count(distinct platform)>1
)

提示:1093 – You can’t specify target table ‘order_all_detail’ for update in FROM clause

解决方法：

再加一层子查询:

update bi_data.order_all_detail
set err_msg='同时存在于wx,zfb平台',proc_time=now()
where order_no in
(
select order_no
from (
select order_no
from bi_data.order_all_detail
group by order_no
having count(distinct platform)>1
) tt
)