---查询重复字段
SELECT 字段A,COUNT(*) FROM 表名 GROUP BY 字段A HAVING count( 字段A) > 1;
----- 修复重复字段
set @rownum=2018200;
update 表名
SET 字段名 = CONCAT('AAAAA',(
select @rownum := @rownum +1 as aa))
where 字段名='AAAAA2018090011';
---查询重复字段
SELECT 字段A,COUNT(*) FROM 表名 GROUP BY 字段A HAVING count( 字段A) > 1;
----- 修复重复字段
set @rownum=2018200;
update 表名
SET 字段名 = CONCAT('AAAAA',(
select @rownum := @rownum +1 as aa))
where 字段名='AAAAA2018090011';