Skip to content

Instantly share code, notes, and snippets.

@Faizanq

Faizanq/MySql GroupBy Error

Last active September 20, 2021 02:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Faizanq/91bc758302fcf739d41625a3ad7f2962 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Faizanq/91bc758302fcf739d41625a3ad7f2962 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySql GroupBy Error
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';
or
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