mysql中去重sql:
保留重复记录中最大id的记录,其他删除.
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.