Skip to content

Instantly share code, notes, and snippets.

@NimzyMaina

NimzyMaina/disable.sql

Created October 4, 2017 15:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NimzyMaina/5afc00362133fb6f7a2ca6af87cc2e93 to your computer and use it in GitHub Desktop.
Save NimzyMaina/5afc00362133fb6f7a2ca6af87cc2e93 to your computer and use it in GitHub Desktop.
Download ZIP
Disable MYSQL Strict Mode
Raw
disable.sql
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment