Problems with navicat and MYSQL5.7

Question

Scenes

Run the insert statement in navicat's query interface to report an error, such as the following statement

insert into tb_messagepermission(messageID,employeeID) values(16,3321)

mistake

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solution

method one

Don’t worry, it has been successfully run in MYSQL and the corresponding content exists

Method 2

Upgrade navicat, or run SQL directly under the MYSQL command line without navicat.

Answer 1

Judging from your error message, the error should not be caused by your insert statement, but by a subsequent select statement. The reason is the setting problem of sql_mode

Reference[](http://m.blog.csdn.net/articl...