Skip to content

Instantly share code, notes, and snippets.

@aginanjar

aginanjar/change_sql_mode.md

Last active June 20, 2016 06:01
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Raw
change_sql_mode.md

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