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.