MySQL 删除重复行

delete from sys_user_import using (sys_user_import,(select distinct min(id) as id  from sys_user_import t group by t.loginname having count(*)>1) as t2 ) 
where  sys_user_import.id > t2.id;