<p>MySQL5.7版本sql_mode=only_full_group_by问题解决办法。sql语句查询使用GROUP BY出现报错：</p><p>具体出错提示：</p><pre class="brush:html;toolbar:false">[Err]&nbsp;1055&nbsp;-&nbsp;Expression&nbsp;#1&nbsp;of&nbsp;ORDER&nbsp;BY&nbsp;clause&nbsp;is&nbsp;not&nbsp;in&nbsp;GROUP&nbsp;BY&nbsp;clause&nbsp;and&nbsp; contains&nbsp;nonaggregated&nbsp;column&nbsp;&#39;information_schema.PROFILING.SEQ&#39;&nbsp; which&nbsp;is&nbsp;not&nbsp;functionally&nbsp;dependent&nbsp;on&nbsp;columns&nbsp;in&nbsp;GROUP&nbsp;BY&nbsp;clause;&nbsp; this&nbsp;is&nbsp;incompatible&nbsp;with&nbsp;sql_mode=only_full_group_by</pre><p><strong>1、查看sql_mode</strong></p><pre class="brush:sql;toolbar:false;">select&nbsp;@@global.sql_mode</pre><p>查询出来的值为：</p><pre class="brush:sql;toolbar:false">ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</pre><p><strong>2、去掉ONLY_FULL_GROUP_BY，重新设置值。</strong></p><pre class="brush:sql;toolbar:false">set&nbsp;@@global.sql_mode&nbsp;=&#39;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&#39;;</pre><p>好了，以上就是关于“MySQL5.7版本sql_mode=only_full_group_by问题解决办法”的全部内容了，小伙伴们如果有更好的建议，欢迎到文章下面的评论区留言告诉我们。</p>