澳门新葡萄京娱乐网站-澳门新葡萄京888官网-所有平台

热门关键词: 澳门新葡萄京娱乐网站,澳门新葡萄京888官网

[Err] 1055 - Expression #1 of O奥德赛DE昂科雷 BY clause

作者: MySQL数据库  发布:2019-12-11

问题:[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_mode=only_full_group_by

MySQL 5.7.9版本sql_mode=only_full_group_by问题

用到GROUP BY 语句询问时com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'col_user_6.a.START_TIME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by错误

 

用到GROUP BY 语句询问时com.MySQL.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'col_user_6.a.START_TIME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by错误

缓慢解决形式 :实践SET GLOBAL sql_mode = ''; 把sql_mode 改成非only_full_group_by方式。验证是不是见效 SELECT @@GLOBAL.sql_mode 或 SELECT @@sql_mode

 

执行SET GLOBAL sql_mode = ''; 把sql_mode 改成非only_full_group_by模式。

SET sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';'

施工方案:

表达是不是见到效果 SELECT @@GLOBAL.sql_mode 或 SELECT @@sql_mode

原来的小说链接:

select version(),
@@sql_mode;SET sql_mode=(SELECT REPLACE(@@sql_澳门新葡萄京888官网,mode,'ONLY_FULL_GROUP_BY',''));

SET sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGI

 

如上所述是笔者给大家介绍的缓慢解决MySQL 5.7.9本子sql_mode=only_full_group_by难点,希望对我们持有助于,假设大家有其余疑问请给自家留言,小编会及时还原大家的。在这里也非常感激大家对剧本之家网址的帮衬!

 

 

澳门新葡萄京888官网 1

 

全盘的应用方案是:

 

1 show variables like "sql_mode";
2 
3 set sql_mode='';
4 set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

澳门新葡萄京888官网 2

 

本文由澳门新葡萄京娱乐网站发布于MySQL数据库,转载请注明出处:[Err] 1055 - Expression #1 of O奥德赛DE昂科雷 BY clause

关键词: