mysql函数运算符

CONCAT(s1,s2...sn) 字符串 s1,s2 等多个字符串合并为一个字符串

SELECT CONCAT("SQL ", "Runoob ", "Gooogle ", "Facebook") AS ConcatenatedString;

CONCAT_WS(x, s1,s2...sn) 同 CONCAT(s1,s2,...) 函数，但是每个字符串之间要加上 x，x 可以是分隔符

 

 

函数

https://www.runoob.com/mysql/mysql-functions.html

 运算符

 https://www.runoob.com/mysql/mysql-operator.html