【mysql】this is incompatible with sql_mode=only_full_group_by
迷茫2017-05-24 11:33:12
0
1
829
This is the group by error of mysql5.7. How to solve it in a Mac environment? There are a lot of Baidu, but it seems that the solution under Mac is not working, please give me some information
sql_model=only_full_group_by限制了，导致在以往MYSQLThe SQL that can be queried normally in version 5.7 cannot be used anymore 1. sudo cp $(brew --prefix mysql)/support-files/my-default.cnf /etc/my.cnf 2 Modify sql_mode sql_mode= STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_pISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 3.mysql.server restart
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
sql_model=only_full_group_by限制了，导致在以往MYSQLThe SQL that can be queried normally in version 5.7 cannot be used anymore1. sudo cp $(brew --prefix mysql)/support-files/my-default.cnf /etc/my.cnf
2 Modify sql_mode sql_mode= STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_pISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3.mysql.server restart