CONCAT
Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form.
Syntax
CONCAT(column1, ...)
Arguments
Arguments | Description |
---|---|
column | string column |
Return Type
A String data type value Or Null data type.
Examples
SELECT CONCAT('data', 'bend');
+------------------------+
| concat('data', 'bend') |
+------------------------+
| databend |
+------------------------+
SELECT CONCAT('data', NULL, 'bend');
+------------------------------+
| CONCAT('data', NULL, 'bend') |
+------------------------------+
| NULL |
+------------------------------+
SELECT CONCAT('14.3');
+----------------+
| concat('14.3') |
+----------------+
| 14.3 |
+----------------+