mysql 删除表中重复数据
DELETE FROM table_name WHERE id not in(SELECT min(id) ids FROM table_name WHERE enable=1 GROUP BY bank_id)
mysql中delete、update 操作,不能在同一表中查询的数据作为同一表的更新数据
因此上方sql执行时要报错,需要对查询语句进行包装,如下:
DELETE FROM table_name WHERE id not in(SELECT ids FROM (SELECT min(id) ids FROM table_name WHERE enable=1 GROUP BY bank_id)ts)
执行成功
mysql 删除表中重复数据
最新推荐文章于 2024-07-30 08:00:00 发布