mysql 删除重复行

1.删除user_id 和 add_time 相同的行

delete from t_park_customer_statistics where id in ( select * from ( SELECT MAX(id) id FROM t_park_customer_statistics cs GROUP BY cs.user_id,cs.add_time HAVING COUNT(1)>1 ) t )

 注意：子查询去掉外面一层的select回报如下错误 

错误代码： 1093You can't specify target table 't_park_customer_statistics' for update in FROM clause

只有MYsql才会报错

DELETE FROM t_park_customer_statistics WHERE id IN ( SELECT MAX(id) id FROM t_park_customer_statistics cs GROUP BY cs.user_id,cs.add_time HAVING COUNT(1)>1 )

 

转载于:https://www.cnblogs.com/lidaofei1991/articles/6672539.html