/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

0 vote287 views2 answers
What is rownum in oracle
SQL
2 votes258 views1 answer
Oracle table size
SQL
0 vote268 views1 answer
SQL SELECT-Klausel
SQL
0 vote275 views1 answer
How to get parent and child record in single query using sql
SQL
22 votes263 views4 answers
Mysql date format
SQL
3 votes289 views6 answers
Jwt laravel
SQL
0 vote283 views1 answer
Proc sql not in working
SQL
1 vote257 views1 answer
Oracle index partition
SQL
11 votes271 views4 answers
MYSQL LOGIN
SQL
0 vote279 views1 answer
Sql sum if
SQL