mysql字段A复制到字段B,并替换指定字符 update `table` set 字段b=replace(字段b,'3366',字段a); eg:update `hy_b_pro` set goldWeight=jinJinZhong;