Add the setting NO_ZERO_IN_DATE to the SQL_MODE system variable. : CONCAT « String « SQL / MySQL






  1. SQL / MySQL
  2. String
  3. CONCAT

Add the setting NO_ZERO_IN_DATE to the SQL_MODE system variable.

      
mysql>
mysql> SET @@SQL_MODE = CONCAT(@@SQL_MODE,CASE @@SQL_MODE WHEN '' THEN '' ELSE ',' END, 'NO_ZERO_IN_DATE');
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql>








Related examples in the same category

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.To combine strings rather than pull them apart, use the CONCAT( ) function.
7.Concatenating Character Strings
8.Concatenation can be useful for modifying column values "in place."
9.Non-ISO results from the CONCAT( ) operation can be converted into ISO format three different ways as follows:
10.Generate Unique Sequential Numbers
11.Use Concat to create Initial for the name