MySQL8sql_model的问题

[/propatientWeb/getPatientAllChannalList] 出现异常，方法：com.yixin.basic.controller.web.ProPatientWebController.getPatientAllChannalList，异常摘要： ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cloud_basic.pro_patient.channel_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ### The error may exist in class path resource [mapper/patient/ProPatientDao.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select channel_id as channelId,channel_name as channelName from pro_patient where is_enabled = ‘1’ and channel_id is not null group by channel_id ### Cause: java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cloud_basic.pro_patient.channel_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘cloud_basic.pro_patient.channel_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

一。解决方法：
1.mysql -u登录账号 -p密码
2.SELECT @@GLOBAL.sql_mode;
3.set @@GLOBAL.sql_mode=’ ';
4.set sql_mode =
‘STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_ENGINE_SUBSTITUTION’;
5.SELECT @@sql_mode;

二。在 [mysqld]和[mysql]下添加加粗样式
set sql_mode =
‘STRICT_TRANS_TABLES,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_ENGINE_SUBSTITUTION’;