Skip to content

Instantly share code, notes, and snippets.

@aginanjar
Last active June 20, 2016 06:01
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 aginanjar/ac4abbe92424157f2a28 to your computer and use it in GitHub Desktop.
Save aginanjar/ac4abbe92424157f2a28 to your computer and use it in GitHub Desktop.

How to change sql mode on MySQL


I'm using MySql v 5.7.9. After googling, found some interesting article.

Go through SQL Client, then paste some code SELECT @@sql_mode;. And taraaa~ it shows me this result : ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION.

Just set sql_mode to '' with this command SET sql_mode = ''; OR SET GLOBAL sql_mode = ''; Hope it'll helps. =D

Good luck.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment