update video_pool_files set new_path=replace(new_path,'O:','G:/o') WHERE new_path like '%O:/cnliveWorkSpace/%' 说明:把 O:/cnliveWorkSpace/ 替换城 G:/o/cnliveWorkSpace/%
update video_pool_files set new_path=replace(new_path,'O:','G:/o') WHERE new_path like '%O:/cnliveWorkSpace/%' 说明:把 O:/cnliveWorkSpace/ 替换城 G:/o/cnliveWorkSpace/%