/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 vote232 views1 answer
Power bi find all ids not in other tables
SQL
12 votes254 views6 answers
Distinct in sql server
SQL
12 votes226 views4 answers
Import mysql database command line linux
SQL
1 vote223 views1 answer
Oracle case
SQL
2 votes248 views3 answers
How to check current user in mySQL
SQL
2 votes273 views3 answers
How to replace null values in sql
SQL
0 vote232 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
1 vote257 views1 answer
Insert many to many sql
SQL
3 votes233 views2 answers
Postgresql select all column names
SQL
2 votes254 views2 answers
How to run postgresql in linux
SQL