因数据重复导入了数据库,需要把重复的记录查找出来并且删除掉,只保留id小的哪一个记录
1、经过测试,可以查找出重复的记录:
SELECT * FROM deviceman.deviceman_user_list WHERE full_name IN (SELECT full_name FROM deviceman.deviceman_user_list GROUP BY full_name HAVING COUNT(full_name)>1);
2、以下sql语句可以删除重复的记录,保留id小的哪一个记录
Delete
HZT
Where
ID
Not
In
(
Select
Max
(ID)
From
HZT
Group
By
Title)