/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

27 votes345 views3 answers
Mysql delete row
SQL
5 votes297 views1 answer
Oracle sysdate - 1 month
SQL
0 vote264 views1 answer
Postgres float to int
SQL
0 vote319 views1 answer
Sqlite trim
SQL
0 vote288 views1 answer
Get number of rows in every table mysql
SQL
5 votes268 views1 answer
Sql first day of current year
SQL
0 vote285 views1 answer
Sql server sleep
SQL
0 vote282 views1 answer
How to use lower case in mysql
SQL
-2 votes299 views1 answer
Trunc in sql
SQL
1 vote242 views1 answer
Oracle character set
SQL