Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
In guides, you often see things like:
Get current mode: SHOW VARIABLES LIKE sql_mode";
Disable: mysql> SET sql_mode = '';
Enable: mysql> SET sql_mode = 'STRICT_ALL_TABLES'; (or STRICT_TRANS_TABLES).
https://stackoverflow.com/questions/38471018/when-to-use-strict-mode-in-mysql-or-mariadb
However, AFAIK, this doesn't just enable or disable strict mode, it affects all other sql mode bits as well.
A better way to toggle sql mode bits would be nice..
`set sql_mode_strict_all_tables = true` would be the ideal.