mysql 查询字段拼接
Mysql的查询结果行字段拼接,可以用下面两个函数实现: 1. concat函数 [ m ](javascript:void(0); "复制代码") <pre style="margin: 0px; padding: 0px; white-space: pre-wrap; overflow-wrap: break-word; font-family: "Courier New" !important; font-size: 12px !important;">mysql> select concat('1','2','3') from test ; +---------------------+ | concat('1','2','3') | +---------------------+ | 123 | +---------------------+</pre> [ 复制代码 ](javascript:void(0); "复制代码") 如果连接串中存在NULL,则返回结果为NULL: [ 复制代码 ](javascript:void(0); "复制代码"...