Skip to content

Instantly share code, notes, and snippets.

@zenmyo
Created May 12, 2015 09:09
Show Gist options
  • Save zenmyo/260d0e388d5f06ed4a00 to your computer and use it in GitHub Desktop.
Save zenmyo/260d0e388d5f06ed4a00 to your computer and use it in GitHub Desktop.
sqlmode
mysql> select @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql> SET @@GLOBAL.sql_mode=''
-> ;
Query OK, 0 rows affected (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment