Skip to content

Instantly share code, notes, and snippets.

@codeasashu

codeasashu/sql_without_fullmode.sql

Last active June 15, 2017 13:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save codeasashu/fbecb5143e9aea9655b4a6bf41ad8d00 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save codeasashu/fbecb5143e9aea9655b4a6bf41ad8d00 to your computer and use it in GitHub Desktop.
Download ZIP
SET SQl to be used without fullmode only
Raw
sql_without_fullmode.sql
#After login to mysql
## mysql -u <username> -p<password>
#Then execute following command:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
#@link: https://stackoverflow.com/a/36033983/7733768
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment