Skip to content

Instantly share code, notes, and snippets.

@rslhdyt

rslhdyt/disable_only_full_group_by.sql

Created May 24, 2019 11:51
Show Gist options
  • Save rslhdyt/23612b25f3ac59e89091c67c32a6362b to your computer and use it in GitHub Desktop.
Save rslhdyt/23612b25f3ac59e89091c67c32a6362b to your computer and use it in GitHub Desktop.
Download ZIP
[Disable only_full_group_by mysql] How to disable only_full_group_by in mysql 5.* #mysql #troubleshooting #setup
Raw
disable_only_full_group_by.sql
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,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