SQUIER (1055) : Expression #1 of SELECT list is not in GROUP BY clause and cor nonaggregated colum

最新推荐文章于 2025-11-17 16:16:14 发布

原创最新推荐文章于 2025-11-17 16:16:14 发布 · 132 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #数据库

文章描述了在执行数据库查询时遇到的SQUIER1055错误，该错误涉及到SELECT列表中的非聚合列未在GROUPBY子句中。解决方案是调整MySQL的SQL模式，设置为STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION。通过执行这个命令，可以解决不兼容only_full_group_by的问题。

在进行数据库操作时，出现以下报错问题

SQUIER (1055) : Expression #1 of SELECT list is 
not in GROUP BY clause and cor 
nonaggregated column ‘test jsqjtest:time’ which 
is not functionally dependent on columns in 
GROUP BY clause; this is incompatible with 
sql_mode=only full group_by

解决方案, 在mysql 中执行以下语句。

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

再执行原有语句时，则通过~问题解决

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

coreyC

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

钙蛋白酶Calpain酶切位点预测工具 —— GPS-CCD 1.0

幽客独往

04-06

2949

钙蛋白酶Calpain酶切位点预测工具 —— GPS-CCD 1.0

Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

李利科

02-01

3697

执行以下sql报错： SELECT name,sex,location FROM tp_music.singer group by sex; 报错信息： Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tp_music.singer.name’ which is not functionally dependent on columns i

参与评论您还未登录，请先登录后发表或查看评论

MySQL 报错[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregat

小洪帽i的博客

10-12

6324

报错：使用 group by 导致错误 [Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myphp.xiaofei.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_gr

MYSQL 分组报错1055 - Expression #1 of SELECT list is not in GROUP BY...

ZhaZha__Hui的博客

09-19

1156

执行以下语句，将only_full_group_by模式关闭

mysql5.7报错1055, “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

Mr_chenweida的博客

07-10

678

cd /etc/mysql/mysql.conf.d/（没有找到就去 /etc/my.cnf ） sudo vim mysqld.cnf 在[mysqld] 下添加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：/etc/init.d/mysql restart (Debia.

Mysql 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate 报错解决方案

qq_36141369的博客

12-24

968

报错信息：1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxxx.xxxx.xxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.000000s 在

3、数据统计分析与可视化：从数据库查询到图表生成

最新发布

metal的博客

11-17

本文介绍了如何使用Active Record进行数据统计分析，并结合Ruby中的Gruff和Scruffy库实现数据可视化。通过具体案例，展示了薪资分布与饮料对游戏表现影响的分析过程，以及生成玩家表现柱状图的方法。文章还对比了Gruff与Scruffy两大图表库的优缺点，提供了在不同场景下的工具选择建议，并展望了大数据处理、高级图表类型和自动化报表等未来发展方向。

fender squier affinity的材质是什么，拾音器是怎么排列的

02-06

Fender Squier Affinity 系列吉他通常都是用桃花心木制成的，也有一些使用枫木制成的。桃花心木和枫木都是轻质的木材，能够带来较弹性的声音效果。拾音器的排列方式取决于吉他的型号。Fender Squier Affinity 系列...

3、数据统计与可视化：从数据库查询到图表生成

tomato的博客

07-07

本文详细介绍了如何从数据库查询数据并使用 Ruby 进行数据统计与可视化分析。内容涵盖数据分组与聚合、SQL 查询执行、图表生成库（如 Gruff 和 Scruffy）的使用，以及如何通过图表直观展示数据结果。通过实际案例分析了游戏开发公司对玩家数据的分析需求，包括薪资分布与饮料对游戏表现的影响，并探讨了数据可视化在不同领域的拓展应用及未来发展趋势。

8、语音技术先驱：从早期探索到电子时代的突破

blue的专栏

08-28

本文回顾了语音技术从18世纪的机械探索到20世纪电子时代的重要突破。介绍了沃尔夫冈·冯·肯佩伦的说话机器、贝尔实验室荷马·达德利发明的Voder语音合成器，以及AUDREY数字识别系统的发展历程。文章分析了早期语音技术的特点与局限，探讨了推动其发展的市场需求、技术创新和人类梦想等因素，并总结了对现代语音技术的启示，展望了未来在智能交互、多语言支持和场景应用拓展等方面的发展方向。

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains

Mr_yiyang的博客

04-28

603

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xschool.sc_user_message.CREATED_USER’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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

徊忆羽菲

01-06

2611

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'table1.sale_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible...

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains解决

TWJ88936543的博客

07-22

1万+

今天在开发过程中，由于之前项目已经开发完成，完成了数据库迁移，今天在操作的时候，根据分组求和的时候，出现了一个错误： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'btc.a.applicant_unit' which is not functionally dependent

MySQL 报错: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column“

总结复盘，才能不迷失自己！

03-06

1020

1.问题描述MySQL 中出现 “1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column” 错误？

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

山鬼谣的专栏

05-06

7108

环境 MySQL：8+ 在执行类似这样的语句时： SELECT * from template_detail a group by template_id; 然后报错了： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ssm.template_detail.id' which is not functionally dependent on columns

mysql错误-1055 - Expression #1 of SELECT list is not in GROUP BY clause 解决方案

liqinglonguo的博客

06-15

8229

这个错误会发生在mysql 5.7 版本及以上版本mysql 5.7版本以上默认的sql配置是:sql_mode=“ONLY_FULL_GROUP_BY”，这个配置严格执行了"SQL92标准"。找到sql_mode，将其中的ONLY_FULL_GROUP_BY属性去掉，如果没有sql_mode配置，就在 [mysqld]下面追加一下即可。由于开启了ONLY_FULL_GROUP_BY的设置，如果select 的字段不在 group by 中，only_full_group_by不兼容”

mysql报错解决： 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated

危险、的博客

01-25

4110

报错如下： Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 问题出现的原因： MySQL 5.7.5及以上功

ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate