Skip to content

Instantly share code, notes, and snippets.

@gauravds

gauravds/fix.sql

Created April 29, 2023 11:01
Show Gist options
  • Save gauravds/94e34dbd961b7ae4d220e5b079b83631 to your computer and use it in GitHub Desktop.
Save gauravds/94e34dbd961b7ae4d220e5b079b83631 to your computer and use it in GitHub Desktop.
Download ZIP
SELECT list is not in GROUP BY clause and contains nonaggregated column 'db1.tables1.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Raw
fix.sql
SHOW VARIABLES LIKE 'sql_mode';
SET global sql_mode = 'NO_ENGINE_SUBSTITUTION';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment