一、MySQL自带字符串拼接函数
CONCAT 字符串拼接
CONCAT_WS 指定字符串分割拼接字符串拼接
① 语法:CONCAT(str1,str2…)
解释:concat 拼接 str1和str2字符串, 省略号....代表可以多个字符串拼接
示例:
SELECT CONCAT("hello","word");
SELECT CONCAT("how","are","you","?");
结果一: 结果二:
② 语法:CONCAT_WS(separator,str1,str2…)
解释:concat_ws 拼接str1,str2,并且将separator【指定的字符串】分割拼接,....代表多个字符串拼接
示例:
SELECT CONCAT_WS(" ","hello","word");
SELECT CONCAT_WS(",","hello","word");
SELECT CONCAT_WS(" ","how","are","you","?");
结果一:
结果二:
结果三:
---------------------
作者:橙汁丶
来源:CSDN
原文:https://blog.csdn.net/a985548426/article/details/83380466
版权声明:本文为博主原创文章,转载请附上博文链接!