mysql 8.0下的SELECT list is not in GROUP BY clause and contains nonaggregated column
mysql的版本
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.12 |
+-----------+
在执行group by时遇到报错,具体如下
mysql> select * from api_properties GROUP BY file_id order by file_id;
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bim.api_properties.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
记得上次在5.7下也遇到了同样的问题 5.7的
win下修改my.ini,添加
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
启动失败,描述为
2019-08-27T09:22:54.827016Z 0 [ERROR] [MY-011071] [Server] D:\phpstudy_pro\COM\..\Extensions\MySQL8.0.12\\bin\mysqld.exe: Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
2019-08-27T09:22:54.827016Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-08-27T09:22:54.828016Z 0 [Note] [MY-010120] [Server] Binlog end
NO_AUTO_CREATE_USER 在 5.7.* 的日志中提到已废除该模式,在 8.0.11 中删除了
修改设置为
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
重启mysql,问题解决
最新文章
- ASP.NET Core MVC/WebAPi 模型绑定探索
- Entity Famework 的通过IOC注入实现
- NEXTDAY
- Radar之获取排列的UITexture数组
- Linux-sed用法
- 分享一个linux和linux的文件传输【scp无密码传输】
- IP数据报首部校验和算法
- WIN10在安装mysql时,出现“The security settings could not be applied to the database because the connection has failed with the following error. Error Nr. 1045
- Jmeter读取Excel,BeanShell取样器调用rt.jar和jxl.jar
- Oracle 忘记sys与system管理员密码重置操作
- mysql 安装成功以及第一次安装成功初始化密码操作
- JDBC的学习
- Xml文档添加节点和属性
- bootstrap modal插件弹出窗口如何限制最大高度,并且在内容过多时可以滚动显示
- 微信授权,openid 分享
- UC手机浏览器(U3内核)相关文档整理
- Apache POI 读写 Excel 文件
- C# StopWatch的BUG????
- 【Python】求素数-稍加优化
- 三角形xjoi 8.14