update tableName set image = replace(image,'/home/pic/','/home/dataaccess/WT_420114_FHWA_2021092711/renlian/') ;
tableName : 查询的表名
image :数据表字段
'/home/pic/':源image中存在的字符串
'/home/dataaccess/WT_420114_FHWA_2021092711/renlian/':替换后的字符串
2021-12-12 16:32:17
update tableName set image = replace(image,'/home/pic/','/home/dataaccess/WT_420114_FHWA_2021092711/renlian/') ;
tableName : 查询的表名
image :数据表字段
'/home/pic/':源image中存在的字符串
'/home/dataaccess/WT_420114_FHWA_2021092711/renlian/':替换后的字符串