mysql - 停用ONLY_FULL_GROUP_BY(Disable ONLY_FULL_GROUP_BY)

Question

I accidentally enabled ONLY_FULL_GROUP_BY mode like this:

(我不小心启用了ONLY_FULL_GROUP_BY模式，如下所示：)

SET sql_mode = 'ONLY_FULL_GROUP_BY';

How do I disable it?

(如何禁用它？)

  ask by ZviBar translate from so

Answer 1

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

(解决方案1：从MySQL控制台删除ONLY_FULL_GROUP_BY)

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

(解决方案2：从phpmyadmin中删除ONLY_FULL_GROUP_BY)

• Open phpmyadmin & select localhost

  (打开phpmyadmin并选择localhost)

• Click on menu Variables & scroll down for sql mode

  (单击菜单变量并向下滚动至sql模式)

• Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

  (单击编辑按钮以更改值并删除ONLY_FULL_GROUP_BY ，然后单击保存。)