【Mysql】查询数据时报Syntax error or access violation: 1055 Expression #1 of SELECT list is not 错误解决

转载 已于 2024-01-02 17:19:02 修改 · 321 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：https://blog.51cto.com/u_13646572/5361431
文章标签：

#mysql #数据库

于 2023-12-21 20:30:31 首次发布
遇到group查询MySQL错误？可能是版本问题。修改my.ini或my.cnf的sql_mode设置，重启MySQL即可。

group 查询的时候遇到这个错误

网上查了资料，得出结果是 mysql版本问题，修改数据库配置文件即可

找到数据库配置文件windows中my.ini文件或linux中的my.cnf文件，在mysqld中增加

sql_mode=

只加一个这个就可以了。

然后重启一下mysql,搞定。

倍福---连接数据库报错SQLState_4200 Syntax error or access violation
weixin_41883890的博客
04-17 2679
在测试TF6420和SQLServer数据库连接时，报错SQLState_42000 Syntax error or access violation,本文对该报错进行分析。 操作流程 1.1. 问题描述 在TF6420新建配置文件，并和SQLServer数据库做通信测试，报错如下： 1.2. 原因分析 报这个错是SQL语法错误的意思，需要逐个检查配置。如数据库名称、表单名称、ip地址等配置出错。 1.3. 排查流程 首先检查SQLServer服务器是否打开，以及数据库的名称、密码、表单的配置情况，如
TP5使用group报错：1055 Expression #1 of SELECT list is not in GROUP
Light
04-13 773
group报错
mysql： Syntax error or access violation: 1055 Expression #2 of SELECT （错误解决办法）
weixin_43702272的博客
05-21 1178
Mysql报错： SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'seo.ryc_combo_class_cate_list_113.fid' whic...
mysql遇见 of SELECT list is not in GROUP BY clause and contains nonaggregated column
工作中学习，学习中进步
11-02 1690
安装了mysql5.7，用group by 查询时抛出如下异常： Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'userinfo.t_long.user_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only
mysql Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause
weixin_30764137的博客
12-26 625
mysql使用group by 报错: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX.Y.ZZZZ' which is not functionally dependent ...
Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and co
hechenhongbo的博客
06-24 4738
MySQL5.7group by语句报错： Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.road_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible wit
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'foodbot.i.category_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
最新发布
08-01
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'foodbot.i.category_id' which is not functionally ...
Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student_admin.st.teacher_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
05-05
好的，我现在需要解决用户遇到的MySQL错误1055，这个错误与sql_mode=only_full_group_by有关。首先，我得回忆一下这个错误的原因。根据用户提供的引用内容，错误是因为SELECT列表中的某个列不在GROUP BY子句中，并且...
thinkphp5 SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student_admin.st.teacher_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
03-31
当执行带有 `GROUP BY` 子句的查询时，如果选择列表中的某些字段既不是聚合函数的一部分，也没有出现在 `GROUP BY` 列表中，则会抛出类似于 `SQLSTATE[42000]: Syntax error or access violation: 1055` 的错误。...
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student_admin.st.teacher_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
03-31
好的，我现在要解决用户遇到的SQL错误：SQLSTATE[42000]: 1055，这是由于sql_mode=only_full_group_by导致的。首先，我需要理解这个错误的原因。根据用户提供的引用，问题出在SELECT列表中的列没有包含在GROUP BY...
mysql 迁移 PHP网站报错SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list
xocom的专栏
08-27 879
更换了MYSQL 服务器,结果报错：SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP 原因： MySQL 5.7.5和up实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MySQL就会拒绝选择列表、条件或顺序列表引用的查询，这些查询将引用组中未命名的非聚合列，而不是在功能上依赖于.
MYSQL报错：Syntax error or access violation: 1055 Expression #5 of SELECT list is not in GROUP BY
u012015632的博客
02-22 786
直接出解决方案：
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1解决方法
艺术编程
05-25 3306
sql_mode=only_full_group_by参数仅允许包括SELECT列表中的所有列和所有聚合函数的GROUP BY子句。要解决此问题，您应该仔细检查查询，并确保所有必需的列和聚合函数都包含在GROUP BY子集中。如果必要，您可能需要修改查询或调整sql_mode设置，以允许更灵活的GROUP BY子句。使用GROUP BY 语句违背了sql_mode=only_full_group_by。因为mysql版本5.7之后默认的模式是ONLY_FULL_GROUP_BY。
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP
孤单的时候狗作陪！的博客
01-18 3216
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'week2.article.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with
myql报错:Syntax error or access violation: 1055 Expression
apanpan8126的博客
02-24 280
修改mysql配置文件 [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
查询数据时报Syntax error or access violation: 1055 Expression #1 of SELECT list is not 错误解决
reg183的专栏
03-16 2506
group 查询的时候遇到这个错误 网上查了资料，得出结果是 mysql版本问题，修改数据库配置文件即可 找到数据库配置文件windows中my.ini文件或linux中的my.cnf文件，在mysqld中增加 sql_mode= 只加一个这个就可以了。 然后重启一下mysql,搞定。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值