mysql批量修改数据

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/')

 

posted @ 2022-12-05 18:10  花心大萝卜li  阅读(758)  评论(0)    收藏  举报