/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

1 vote263 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote328 views1 answer
How to select only id where is not in column mysql
SQL
3 votes354 views3 answers
Postgresql random number
SQL
1 vote340 views3 answers
Nth highest salary
SQL
1 vote328 views1 answer
Mysql workbench in ubuntu 14.04
SQL
3 votes329 views2 answers
How to start mysql in terminal
SQL
2 votes527 views5 answers
Unique in sql server
SQL
1 vote378 views1 answer
Opensuse restart MySQL
SQL
0 vote332 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote341 views1 answer
How to get nth number in sql
SQL