/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

4 votes231 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote245 views2 answers
Wordpress change url in database
SQL
0 vote258 views1 answer
Connect google bigquery connect using sqirrel
SQL
3 votes196 views2 answers
How to start mysql in terminal
SQL
0 vote209 views1 answer
C# select Mysql
SQL
5 votes206 views1 answer
Oracle create table comment
SQL
0 vote188 views1 answer
Search starting with mysql
SQL
0 vote182 views1 answer
Selects all the columns from the sailors table
SQL
0 vote174 views1 answer
View t-sql mail configuration
SQL
0 vote177 views1 answer
Downgrading sql localdb visual studio
SQL