Mysql Configuration SQL Mode

By:
On:
In: Database
Tagged: , ,

Set my.ini

Use Command

Show

SELECT @@GLOBAL.sql_mode;

Set

SET GLOBAL sql_mode = TRADITIONAL;

Ex

mariadb> SELECT @@GLOBAL.sql_mode;
+-----------------------------------------------------+
| @@GLOBAL.sql_mode |
+-----------------------------------------------------+
| NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------+
1 row in set

mariadb> SET GLOBAL sql_mode = TRADITIONAL;
Query OK, 0 rows affected