执行以下代码报错You can't specify target table '' for update in FROM clause


delete from 
    shop_info 
where 
    shop_id 
in 
(select shop_id from shop_info group by shop_id having count(shop_id)>1)

解决方法

delete from 
    shop_info 
where 
    shop_id 
in 
(select a.shop_id from 
(select shop_id from shop_info group by shop_id having count(shop_id)>1) a
)

转载自：http://blog.csdn.net/priestmoon/article/details/8016121

来自ansion博客 

http://www.tp0.top

2018-03-19 21:09:30