SELECT CONCAT(14.3); : CONCAT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. CONCAT
mysql>
mysql> SELECT CONCAT(14.3);
+--------------+
| CONCAT(14.3) |
+--------------+
| 14.3         |
+--------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> SELECT CONCAT(14.3, 2);
+-----------------+
| CONCAT(14.3, 2) |
+-----------------+
| 14.32           |
+-----------------+
1 row in set (0.00 sec)








23.8.CONCAT
23.8.1.CONCAT(str1,str2,...): Concatenate the arguments
23.8.2.CONCAT() returns NULL if any argument is NULL.
23.8.3.SELECT CONCAT(14.3);
23.8.4.Using CONCAT with table column
23.8.5.Use Concat data from two different columns