mysql连接多个字段数据到一个字段中_MySQL
- WBOYOriginal
- 2016-06-01 13:35:48951browse
bitsCN.com
mysql连接多个字段数据到一个字段中
Sql代码
update CM_CUST set CUST_NAME_CN= concat(CUST_NAME_CN,'(',CERTIFICATE_NO,TELPHONE,')')
其中：CUST_NAME_CN，CERTIFICATE_NO，TELPHONE为表CM_CUST中的三个字段
效果如下图：
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：通过RPM包安装Mysql_MySQLNext article：hibernate保存数据到mysql时的中文乱码问题！_MySQL