mysql表记录去重sql

mysql中去重sql:

保留重复记录中最大ｉｄ的记录，其他删除．

DELETE FROM `table_test`

WHERE `id` NOT IN (
SELECT `id` FROM (SELECT MAX(`id`) AS `id` FROM `table_test` GROUP BY `name`)  AS `t1`

);
#因为子查询中给了表别名t1，可用。如果把别名去掉，则语句报错[Err] 1248 - Every derived table must have its own alias．