Skip to content

Instantly share code, notes, and snippets.

@memandip

memandip/gist:aadaf2eba250095f55cb49cff4f71b57

Created May 10, 2021 08:19
Show Gist options
  • Save memandip/aadaf2eba250095f55cb49cff4f71b57 to your computer and use it in GitHub Desktop.
Save memandip/aadaf2eba250095f55cb49cff4f71b57 to your computer and use it in GitHub Desktop.
Download ZIP
Fix sql_mode ONLY_FULL_GROUP_BY
Raw
gistfile1.txt
functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SET GLOBAL 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