CONCAT « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. CONCAT
1.CONCAT(, [{, }...])
2.Use the CONCAT() and LEFT() functions to create registration codes for the employees.
3.Manipulate retrieved data from the Employees table.
4.Combining a Date and a Time into a Date-and-Time Value
5.Canonizing Not-Quite-ISO Date Strings
6.Add the setting NO_ZERO_IN_DATE to the SQL_MODE system variable.
7.To combine strings rather than pull them apart, use the CONCAT( ) function.
8.Concatenating Character Strings
9.Concatenation can be useful for modifying column values "in place."




10.Non-ISO results from the CONCAT( ) operation can be converted into ISO format three different ways as follows:
11.Generate Unique Sequential Numbers
12.Use Concat to create Initial for the name