MySql> SELECT * FROM ‘ONLY_FULL_GROUP_BY’ WHERE sql_mode = ‘ONLY_FULL_GROUP_BY’
MySql> delete the ONLY_FULL_GROUP_BY item from my.ini; delete the ONLY_FULL_GROUP_BY item from my.cnf
2. If there is no SQL_MODE item in the configuration item, use SQL statement to modify it
Find out sql_mode value
MySql> delete the ONLY_FULL_GROUP_BY item from my.ini; delete the ONLY_FULL_GROUP_BY item from my.cnf
2. If there is no SQL_MODE item in the configuration item, use SQL statement to modify it
Find out sql_mode value
select @@sql_mode
Remove the only_full_group_by item from the value found and add the other items to the my.ini configuration file
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Configuration items in my.ini:
3. Do not modify any configuration files, but add any_value() to fields that do not need to be grouped
SELECT any_value(id),value FROM role group by value;
Read More:
- How to solve MySQL error 1049 (42000): unknown database ‘database’
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- The problem of MySQL database connection failure errno: 1049 error
- The problem of master-slave database synchronization stop caused by MySQL deleting data
- Solve the problem of MySQL 1251 client does not support
- An error is reported when kettle connects Oracle database and MySQL database
- Solve the problem that dbvisualizer cannot connect to mysql8
- (error when importing database): MySQL 2006-mysql server has gone away
- Solve the problem that node. js USES MySQL to connect econnunion 127.0.0.0.1:3306
- Solve the problem of VC 6.0 fatal error C1033: cannot open program database’.\debug\vc60.pdb’
- Solve the problem of error loading MySQL DB module. Encountered during Django project
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
- django.core.exceptions . improveconfigured: error loading MySQL DB module. Django configuring MySQL database
- PHP connection to MySQL database error: call to undefined function MySQL_ connect()
- java.lang.ClassNotFoundException : com.mysql.jdbc . driver project cannot connect to database, exception, lack of MySQL driver
- How to solve the problem of “08001” when JDBC connects to MySQL
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution