Skip to content

Instantly share code, notes, and snippets.

@peterkracik
Last active April 16, 2019 07:57
Show Gist options
  • Select an option

  • Save peterkracik/5439530baaf559a48b995bade3c0b4f8 to your computer and use it in GitHub Desktop.

Select an option

Save peterkracik/5439530baaf559a48b995bade3c0b4f8 to your computer and use it in GitHub Desktop.
MYSQL 5.7: group by error
set session sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
set global sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment