Mysql-[err] 1055-expression #1

? Copyright NOTICE: This article is the original blogger article, reproduced please indicate the source

problem Description: Execute SQL statement under MySQL database, error (although SQL is also successful, it's not cool to watch). The error message is as follows:

Solution:

First, go to the root directory of MySQL to find My-default.ini configuration file, open after the Sql_mode in the only_full_group_by deleted

Second, execute SELECT @ @sql_mode statement

Third, if there is only_full_group_by, delete it after the update record, as follows

Four, the problem is solved, but the above method is only the current session, after re-entry MySQL problem persists, completely solve the following

Mysql-[err] 1055-expression #1