/SQL/Mysql remove only_full_group_by permanently

Mysql remove only_full_group_by permanently

This is incompatible with sql_mode=only_full_group_by

mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Source: stackoverflow.com

Mysql remove only_full_group_by permanently

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
# Add this line in last 
#-----------------------
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
#-----------------------

#Save file and exit
sudo systemctl restart mysql

Source: tableplus.com

Similar codes

3 votes195 views1 answer
Mysql insert on dupèlicate
SQL
2 votes168 views1 answer
Drop table if exists in postgres
SQL
0 vote171 views1 answer
Bigquery declare
SQL
1 vote182 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote187 views1 answer
Get primary key of table
SQL
10 votes152 views2 answers
Sql where clause multiple values
SQL
0 vote190 views1 answer
Mariadb create index if not exists
SQL
19 votes211 views3 answers
Grant mysql
SQL
0 vote186 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote187 views5 answers
What is in operator in sql
SQL