Open left0ver opened 3 months ago
https://blog.leftover.cn/2024/06/03/%20MAC%E4%B8%ADMysql%E7%9A%84GROUP%20BY%E5%85%B3%E9%97%ADonly_full_group_by%E6%A8%A1%E5%BC%8F%E6%96%B9%E6%B3%95/#more
MAC中Mysql的GROUP BY关闭only_full_group_by模式方法 找到mysql的配置文件,若没有则创建一个, 1sudo vim /etc/my.cnf 添加下面的内容 12[mysqld]sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO
https://blog.leftover.cn/2024/06/03/%20MAC%E4%B8%ADMysql%E7%9A%84GROUP%20BY%E5%85%B3%E9%97%ADonly_full_group_by%E6%A8%A1%E5%BC%8F%E6%96%B9%E6%B3%95/#more
MAC中Mysql的GROUP BY关闭only_full_group_by模式方法 找到mysql的配置文件,若没有则创建一个, 1sudo vim /etc/my.cnf 添加下面的内容 12[mysqld]sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO