mysql 删除重复数据保留最新一条

delete FROM t_china_policy2 WHERE id in
(
select id from (
SELECT
ta.id
FROM
t_china_policy2 AS ta
WHERE
ta.id <> ( SELECT max( tb.id ) FROM t_china_policy2 AS tb WHERE ta.title = tb.title ))t);

posted @ 2020-01-15 09:13  向之礼  阅读(317)  评论(0编辑  收藏  举报