/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 vote366 views1 answer
Mysql set variable to today's date
SQL
3 votes327 views2 answers
Oracle for loop
SQL
-2 votes357 views2 answers
Union vs union all in sql
SQL
1 vote369 views1 answer
Hackerrank sql test solutions
SQL
0 vote372 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
24 votes378 views5 answers
List mysql users
SQL
0 vote354 views1 answer
Mysql multiple count
SQL
4 votes391 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
2 votes352 views2 answers
Sql strip non alphanumeric characters
SQL
7 votes343 views6 answers
Group_concat mysql
SQL