search

Home >Database >Mysql Tutorial >mysql字符串链接与值设置_MySQL

mysql字符串链接与值设置_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:34:03912browse

bitsCN.com


mysql字符串链接与值设置

 

update `vip_guest` set invite_name =( 

 

case when invite_name is null  then  NULL 

 

case when invite_name is not null then  CONCAT('0',invite_name) 

 

else "" 

 

)

 

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL5.5加主键锁读问题_MySQLNext article：mysql用户权限管理_MySQL

Related articles

See more