![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
文章平均质量分 60
casainurbania
这个作者很懒,什么都没留下…
展开
-
解决SELECT list is not in GROUP BY clause and contains nonaggregated column..
问题描述在一次zabbix库中写联合查询语句时报错1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xxxx.xxx’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by原创 2020-07-28 16:40:58 · 5604 阅读 · 0 评论 -
ERROR 1193 (HY000) at line 38: Unknown system variable ‘storage_engine‘解决
在导入employee训练集的时候报错INFOCREATING DATABASE STRUCTUREERROR 1193 (HY000) at line 38: Unknown system variable ‘storage_engine’employees.sql 第38行:set storage_engine = InnoDB;原因是MySQL5.7.5版本以后这个变量被...原创 2020-04-08 16:34:59 · 2688 阅读 · 2 评论