mysql批量修改重复字段与查询某一字段重复

---查询重复字段

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';

 

转载于:https://my.oschina.net/u/3145956/blog/3089202