Skip to content

Instantly share code, notes, and snippets.

@wenpeng

wenpeng/gist:8867418ce67abdf887829f316c6cc70c

Created March 27, 2017 11:15
Show Gist options
  • Save wenpeng/8867418ce67abdf887829f316c6cc70c to your computer and use it in GitHub Desktop.
Save wenpeng/8867418ce67abdf887829f316c6cc70c to your computer and use it in GitHub Desktop.
Download ZIP
SQL，批量为字段的值增加前缀
Raw
gistfile1.txt
update forumdata_userttt set userLink=concat('http://weibo.com/',userLink) where id>198;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment