UPDATE meteo_forecast_item SET forecast_path =REPLACE(forecast_path,'/data/jjj-smart-grid','/home/jjj-smart-grid/data') UPDATE qiyun_station_sequential SET file_path =REPLACE(file_path,'/data/jjj-smart-grid','/home/jjj-smart-grid/data') UPDATE qiyun_station_image SET image =REPLACE(image,'http://10.225.2.139:21011/','http://192.168.124.82:21011/')
标签：批量,REPLACE,修改,grid,jjj,mysql,path,data,smart From： https://www.cnblogs.com/Lcch/p/16953091.html