String Concatenation Using concat Function

Unlike SQL Server, String concatenation works using a function. It’s a simple function that you pass comma separated values into in the order you want them concatenated. The 1st value you pass will be at the beginning of the new string, the last will be last.

mysql> SELECT CONCAT('put ','these',' together') as str;
+------------------------------------+
| str |
+------------------------------------+
| put these together                 |
+------------------------------------+
1 row in set (0.01 sec)

Leave a Reply

Your email address will not be published.