MySQL 删除重复行语句代码
时间:2014-11-02 19:58 来源:linux.it.net.cn 作者:it
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; (责任编辑：IT)
| 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; (责任编辑：IT) |