Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save jonasporto/c171ef7722b84d19328182069f76391c to your computer and use it in GitHub Desktop.
Save jonasporto/c171ef7722b84d19328182069f76391c 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