Home >Database >Mysql Tutorial >mysql两列合成一列_MySQL
mysql两列合成一列_MySQL
- WBOYOriginal
- 2016-05-31 08:46:201261browse
比如：有姓和名两列，我想查询的结果为一列。就需要concat关键字了。sql如下：
select concat(firstName,lastName) from tj_user
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：MySQLSELECT语句_MySQLNext article：MySQLFabric部署_MySQL