mysql 常用sql记录

1、替换表中某字段的某部分字符串

  update tasktemplate set taskreferphotourl = replace(taskreferphotourl,"/marketmix","/marketdata")

posted @ 2020-12-22 13:57  风信子one  阅读(70)  评论(0编辑  收藏  举报