update  zs_goods set `goods_img`=replace (`goods_img`,"http:\/\/zhencheng2.oss-cn-beijing.aliyuncs.com","http:\/\/xuanchuance.oss-cn-beijing.aliyuncs.com\/zhencheng2");

更改 zs_goods表里面的goods_img字段，把字段goods_img里面的“http:\/\/zhencheng2.oss-cn-beijing.aliyuncs.com”字符串批量替换成“http:\/\/xuanchuance.oss-cn-beijing.aliyuncs.com\/zhencheng2”，注意转义符号。