mysql修改a=a+1

UPDATE tpl_md_site a,(SELECT MIN(id) AS id,site_code FROM tpl_md_site GROUP BY site_code HAVING COUNT(*)>1) b SET a.site_code = CONCAT(b.site_code,'_9') WHERE a.id = b.id