禁用 ONLY_FULL_GROUP_BY [英] Disable ONLY_FULL_GROUP_BY

问题描述

我不小心启用了 ONLY_FULL_GROUP_BY 模式:

SET sql_mode = 'ONLY_FULL_GROUP_BY';

如何禁用它?

解决方案

解决方案 1:从 mysql 控制台删除 ONLY_FULL_GROUP_BY

mysql >SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

您可以在

I accidentally enabled ONLY_FULL_GROUP_BY mode like this:

SET sql_mode = 'ONLY_FULL_GROUP_BY';

How do I disable it?

解决方案

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

you can read more here

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

• Open phpmyadmin & select localhost
• Click on menu Variables & scroll down for sql mode
• Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

这篇关于禁用 ONLY_FULL_GROUP_BY的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！