MySql version: the perfect solution for SQL _mode = only_full_group_by,

MySql version: the perfect solution for SQL _mode = only_full_group_by,

1. View SQL _mode

Select @ SQL _mode

The queried value is:

ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

2. Remove ONLY_FULL_GROUP_BY and reset the value.

Set @ SQL _mode = 'strict _ TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION ';

3. The above changes the global SQL _mode, which is effective for the newly created database. For an existing database, run the following command under the corresponding data:

Set SQL _mode = 'strict _ TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION ';

The above is the perfect solution for MySql version problem SQL _mode = only_full_group_by introduced by xiaobian. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!