mysql 1093 from for update_mysql的1093错误You can't specify target table 't' for update in FROM clause ...

最新推荐文章于 2024-08-21 08:47:50 发布

mizore

最新推荐文章于 2024-08-21 08:47:50 发布

阅读量184

点赞数

文章标签： mysql 1093 from for update

本文链接：https://blog.csdn.net/weixin_39595320/article/details/113904796

版权

mysql>delete from twhere id in (select idfrom t where id < 5);

ERROR1093 (HY000): You can't specify target table 't' for update in FROM clause

改为下面就OK

deletefrom t where id in(select * from ((select idfrom twhere id <5) tmp);

主句(select * from (从句temp)

删除重复，但保留最小id项。

DELETE FROM file WHERE fileaddress IN ( select * from (( SELECT fileaddress FROM file GROUP BY fileaddress HAVING count(fileaddress) > 1 ) a) ) AND id NOT IN ( select * from (( SELECT min(id) FROM file GROUP BY fileaddress HAVING count(fileaddress) > 1 ) b) )