sql 替换


update "PUBLIC"."CB_MENU" set "URL" =replace("URL",'192.8.200.74:8080','129.204.105.183:8181')

 

mysql 

 update kd_avg set ip=replace(ip,'192.168.43.2','192.168.43.18')

posted @ 2020-06-03 09:46  天之泉  阅读(412)  评论(0)  编辑  收藏  举报