mysql 根据字段删除重复记录

来源:互联网 发布:ubuntu openstack安装 编辑:程序博客网 时间:2024/03/29 20:40
DELETE table AS a  FROM table AS a,       (SELECT *          FROM table        GROUP BY column        HAVING count(1) > 1) AS b WHERE a.column = b.column AND a.id > b.id;

0 0
原创粉丝点击