1.使用以下SQL查询语句查找重复的数据行:
SELECT field_name, COUNT(*) FROM table_name GROUP BY field_name HAVING COUNT(*) > 1;
2.删除重复字段数据:
DELETE FROM table_name WHERE field_name IN ( SELECT field_name FROM ( SELECT field_name, ROW_NUMBER() OVER (PARTITION BY field_name ORDER BY field_name) AS row_num FROM table_name ) t WHERE row_num > 1 );
3.设置唯一键值
ALTER TABLE table_name DROP INDEX field_name;//如果之前有设置
ALTER TABLE table_name ADD CONSTRAINT constraint_name UNIQUE (field_name);