mysql

删除重复记录
delete from test
where
id NOT IN(
select id from(
select min(id) id from test group by aa)t
)