mysql
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 · 5581 阅读 · 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 · 2540 阅读 · 2 评论