随笔分类 -  MySql

Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4800!
摘要：# 1、问题截图 cat /var/log/mysql/error.log ``` sql 2019-01-28T09:49:57.076019Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the f 阅读全文
posted @ 2023-07-01 12:51 mua~mua~ 阅读(641) 评论(0) 推荐(0) 编辑
mysql5.7以后group by 报错 sql_mode=only_full_group_by的解决方法
摘要：一、发现问题 1、查询语句 SELECT * from class group by class_name; 2、报错结果 ..... this is incompatible with sql_mode=only_full_group_by; 二、原因 mysql 5.6 版本后。默认启用了ONL 阅读全文
posted @ 2020-11-24 15:57 mua~mua~ 阅读(2395) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示