解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat

最新推荐文章于 2024-03-25 14:21:37 发布
最新推荐文章于 2024-03-25 14:21:37 发布
阅读量4.7k 收藏
点赞数
分类专栏： 数据库 文章标签： apollo
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010081710/article/details/100656551
版权

初始化apollo-portaldb 数据库时报错

问题解决

1、 解决办法： 把 sql_mode中的 only_full_group_by 去掉即可。

2、 办法一 （摘自 这里 只在当前查询页面有效，不能一次性解决问题！）：

  • select version(), @@sql_mode;
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
The MySQL 8.0.0 Milestone Release is available
帅的数说
09-20 1890
http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/ The MySQL Development team is happy to announce our 8.0.0 development milestone release (DMR), now available for downloa
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
赵大白
07-11 626
完整错误### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'a.add_...
mysql5.7 group报错ERROR 1055 (42000): Expression #1
Marhal的博客
03-27 754
ubuntu16.04 apache2.4 php7.0 mysql5.7 $order_goods=db('order_goods')->where('orderid','in',$_orderid_arr)->group('orderid')->having('id>0')->select(); echo db('order_goods')->getL...
SQL---Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '
IT云清
12-27 5168
数据库中插入数据或执行sql语句时一直报下面这个错误： Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on c...
mysql sql_mode小分享
王鹏的专栏
07-17 805
mysql sql_mode参数小节 mysql，sql实例SELECT charges,mealstime,name,sd_meal.id,fixedcharges,balancecharges,payablecharges FROM sd_meal,lcmemdata,sd_conservation WHERE sd_meal.childuid=lcmemdata.childi
解决MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonag...
Jitwxs
02-25 4898
一、问题描述 运行 sql 后报错： Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘day_offset’ which is not functionally dependent on columns in GROUP BY clause; this is in...
MySQL查询列必须和group by字段一致吗？
superjava_的博客
12-30 284
场景：查询各部门薪水最高的员工。 MySQL group by是如何决定哪一条数据留下的？ 那么target list和group by column不匹配就一定不能执行吗？ MySQL版本：8.0.27 场景：查询各部门薪水最高的员工。 CREATE TABLE `employee` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID', `dept` int NOT NULL COMMENT '部门', `user` varchar(
MySQL操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu
最新发布
蛤？
03-25 1532
Mysql数据库操作报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat。这个问题主要是由于sql_mode引起，所以先查看sql_mode 然后修改即可，主要是去除only_full_group_by。说明：此方法可以解决大部分mysql8出现的上述报错，配置之后若不生效或启动错误需删除以上配置并需求新的解决方案。
mysql5.7执行sql报错1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
barry200890的专栏
12-14 994
执行sql时报错，具体报错如下： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat...
weixin_30336061的博客
02-19 733
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat 转自：https://blog.csdn.net/HaHa_Sir/article/details/80503601 2018年05月29日 23:10:52HaHa_Sir...
解决MySQL报错：1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘informat
热门推荐
HaHa_Sir的博客
05-29 2万+
解决MySQL报错：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'informat一、问题描述新安装的MySQL5.7.22 或 8.0.11，在 Navicat 上执行删除操作时，遇到报错：[Err] 1055 - Expre............
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema
weixin_44517656的博客
01-26 445
1 解决 ORDER BY clause is not in GROUP BY update时出现下面的问题，然后很自然的去百度，他们说需要改模式或者配置文件。但是我之前update时都是可以的，凭什么过了半天就不行了，于是从sql语句查问题，结果sql语句也没错，那究竟是什么问题呢，我也不知道为啥突然报错，解决方法重启nvicat即可。 反正我是重启之后就能成功执行。 不建议改mysql的配置。 1 of ORDER BY clause is not in GROUP BY clause and con
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated..
zq33312757的博客
11-10 1万+
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY
解决mysql报错：- Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated co...
diwei8531的博客
05-07 742
mysql执行报错： - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GRO...
1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘apimonitor.t.cr...
jyjj_的博客
04-19 200
修改数据表 ENGINE = MyISAM 后，执行任何查询语句都会报告该错误，在试了一些博客的方法后解决；如下： sql版本 window mysql 8.0 修改mysql配置文件 my.ini，在最后一行添加 sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' 再重启mysql即可。 ...
MySQL错误Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colum
Janet_5的博客
07-24 2103
程序提示错误：Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 原因：数据库sq...
mysql 5.7 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated colu...
weixin_30687587的博客
09-09 873
使用mysql在执行一条插入语句时 insert into channel(channel_id, channel_no,channel_name) values(1, '1000', "hhh"); 报错：Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated...
mysql报错：ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
总结经验，与君共勉
12-05 1万+
在mysql5.7之后的版本运行sql语句时，出现以下问题： [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally de...
MySQL解决报错：Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column. macbook怎么解决这个报错
12-27
在MySQL中，当使用GROUP BY子句对结果进行分组时，SELECT列表中的列必须要么是分组的列，要么是聚合函数的结果。否则，会出现报错"Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"。解决这个报错的方法有两种： 1. 使用聚合函数对非分组列进行聚合操作。 2. 修改MySQL的sql_mode参数，将其设置为非严格模式。 下面是两种解决方法的示例： 方法一：使用聚合函数对非分组列进行聚合操作 ```sql SELECT custname, MAX(salary) FROM your_table GROUP BY custname; ``` 方法二：修改MySQL的sql_mode参数 ```sql SET sql_mode = 'ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER'; ``` 请注意，修改sql_mode参数可能会影响其他查询的行为，因此在修改之前请确保了解其影响。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值