当前位置:Gxlcms > 数据库问题 > In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'emsdb_pro.mainspareparts.CreationTime'; this is incompatible with sql_mode=only_full_group_by

In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'emsdb_pro.mainspareparts.CreationTime'; this is incompatible with sql_mode=only_full_group_by

时间:2021-07-01 10:21:17 帮助过:9人阅读

在使用select @@global.sql_mode查询

结果中就不存在

ONLY_FULL_GROUP_BY

技术图片

 

In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'emsdb_pro.mainspareparts.CreationTime'; this is incompatible with sql_mode=only_full_group_by

标签:erro   code   http   ini   ict   art   技术   mode   查询   

人气教程排行