Enter the following codes in MYSQL:
set sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION’;
Note:
if you use copy and paste, please delete the two single quotation marks and type them again, otherwise an error will be reported
if you enter them manually, there is no problem at all
Similar Posts:
- SELECT list is not in GROUP BY clause and contains nonaggregated
- Solve the problem of grouping error expression #1 of select list is not in group for MySQL greater than version 5.7
- [Solved] MYSQL Command gruop by Error: this is incompatible with sql_mode=only_full_group_by
- [Solved] MySQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
- Expression #1 of ORDER BY clause is not in SELECT list, references column ‘xxxx’ which is not in SELECT list; this is incompatible with DISTINCT
- [Solved] MYSQL8 group by Error: Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY
- MYSQL Insert: SQLSTATE[HY000]: General error: 1364 Field ‘xxxxx’ doesn’t have a default value
- [Solved] SELECT list is not in GROUP BY clause and contains nonaggregated
- Laravel uses group by to report errors [How to Solve]
- SELECT list is not in GROUP BY clause and contains nonaggregated column