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

DELETE FROM tb
WHERE id not IN (
	SELECT max_id FROM (
		SELECT max(id) max_id
		FROM tb
		GROUP BY column_1,column_2,...colums
	) temp
)