DELETE FROM 表名 WHERE UUID IN(
SELECT * FROM (
SELECT UUID FROM 表名 AS t1 WHERE t1.UUID !=(
SELECT UUID FROM 表名 AS t2 WHERE t1.相同条件 = t2.相同条件 ORDER BY TS DESC LIMIT 0,1
)
)t
);
mysql实现删除重复语句,保留最新时间的记录
最新推荐文章于 2024-04-24 22:17:47 发布