mysql5.7 Group by查询时的ONLY_FULL_GROUP_BY错误解决办法

作者

mysql> SELECT @@sql_mode; +------------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | +------------------------------------------------------------------------------------------------------------------------+ | 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 | +------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) #方法一： #修改为： mysql> set GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; #方法二： #修改配置文件，去掉ONLY_FULL_GROUP_BY sql_mode = "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"

windows10下开启卓越性能模式

作者

在powershell中输入如下代码，开启卓越性能模式，然后去电源选项中选择卓越性能模式即可安全超频： powercfg -duplicatescheme 8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c powercfg -duplicatescheme e9a42b02-d5df-448d-aa00-03f14749eb61