MySQL Error 1093(HY000)

最新推荐文章于 2024-05-13 17:32:37 发布

acmer1183

最新推荐文章于 2024-05-13 17:32:37 发布

阅读量649

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/acmer1183/article/details/44457513

版权

mysql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

mysql> delete mco.* from mcotest as mco where mco.id in( select mo.id from mcotest as mo inner join mcotest as mo2 on mo.aid=mo2.appid and mo.id<>mo2.id and mo.soid=mo2.soid group by mo.aid );
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3840179
Current database: open360_online
ERROR 1093 (HY000): You can't specify target table 'mco' for update in FROM clause

解决办法，改用联表删除

mysql> delete mco.* from mcotest as mco inner join ( select mo.id from mcotest as mo inner join mcotest as mo2 on mo.aid=mo2.appid and mo.id<>mo2.id and mo.soid=mo2.soid group by mo.aid ) as dup on dup.id=mco.id;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3840216
Current database: open360_online
Query OK, 13 rows affected (4.22 sec)