Skip to content

Instantly share code, notes, and snippets.

@kleberncto

kleberncto/MySQL_Remove_Full_Group_By.txt

Created August 16, 2016 18:36
Show Gist options
  • Save kleberncto/2e6d24a4cf29988d1ea9bf405f9711af to your computer and use it in GitHub Desktop.
Save kleberncto/2e6d24a4cf29988d1ea9bf405f9711af to your computer and use it in GitHub Desktop.
Download ZIP
Remove full group by MySQL
Raw
MySQL_Remove_Full_Group_By.txt
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment