This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,747 Users
  • 2,269,776 Discussions
  • 7,916,827 Comments

Discussions

How configure my.cnf in mysql5.7 with: SET GLOBAL sql_mode = sys.list_drop(@@sql_mode, 'ONLY_FULL_GR

4221600
4221600 Member Posts: 3
edited Apr 15, 2020 4:55AM in MySQL Community Space

Hi,

I have to drop this property from variable sql_mode.

In mysql client I execute:

@sql_mode, 'ONLY_FULL_GROUP_BY');

When I try editing in my.cnf file (and restart the service) I realize that this configuration is not taken this change,

I tried with many options in my.cnf like:

  1. sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  2. sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  3. sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  4. sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  5. sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Anybody know what's happend?, thanks a lot.

Answers