fix: MySQL
July 13, 2020 —
cmcipriano
a simple fix on the "group by" command of MySQL 5.7x
create this file on your home folder, named .my.cnf and put this lines.
[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
put the text above as a one-liner.
Tags: mysql