mysql remove only_full_group_by permanently code example
Example 1: sql_mode=only_full_group_by
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Example 2: this is incompatible with sql_mode=only_full_group_by
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Example 3: mysql remove only_full_group_by permanently
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
sudo systemctl restart mysql