1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mes

select sum(LossTime) as LossTime,a.TEXT_VALUE as LossCauseDescription,LocationId from lossdaydetail l  inner join text   a  on  l.LanguageId=a.STRING_ACRONYM  where  LocationId in('000000002431','000000002432','000000001001') AND  start>='2021-01-20 00:00:00' and end<='2021-01-22 23:59:59'  group by LanguageId,LocationId order by losstime desc

1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'meskpi_m.a.TEXT_VALUE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

 

解决办法：

select @@sql_mode;

set session sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

 

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
 

 

查看mysql 安装位置

 show variables like '%datadir%';

C:\ProgramData\MySQL\MySQL Server 5.7\Data\