MySQL CONCAT方法用法及代碼示例

例子

考慮下表有關一些學生的信息：

可以使用此處的代碼創建上述示例表

基本用法

要將 fname 和 lname 連接起來，中間有一個空格：

SELECT CONCAT(fname, ' ', lname)
FROM students;



+---------------------------+
| CONCAT(fname, ' ', lname) |
+--------------------------+
| Sky Towner                |
| Ben Davis                 |
| Travis Apple              |
| Arthur David              |
| Benjamin Town             |
+---------------------------+

要使用 AS 為結果列提供別名：

SELECT CONCAT(fname, ' ', lname) AS "Full Name"
FROM students;



+---------------+
| Full Name     |
+---------------+
| Sky Towner    |
| Ben Davis     |
| Travis Apple  |
| Arthur David  |
| Benjamin Town |
+---------------+

數值參數

數字參數自動轉換為字符串：

SELECT CONCAT(fname, ' is ', age, ' years old.') AS "Sentence"
FROM students;



+---------------------------+
| Sentence                  |
+---------------------------+
| Sky is 17 years old.      |
| Ben is 19 years old.      |
| Travis is 18 years old.   |
| Arthur is 16 years old.   |
| Benjamin is 17 years old. |
+---------------------------+

空參數

如果任何參數是 NULL ，則返回 NULL ：

SELECT CONCAT('Hello', NULL);



+-----------------------+
| CONCAT('Hello', NULL) |
+-----------------------+
| NULL                  |
+-----------------------+