禁用 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.