/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 vote163 views1 answer
Mysql cdn link
SQL
2 votes175 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote206 views1 answer
Sql server information_schema temp tables
SQL
0 vote203 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote188 views1 answer
What is top n result in sql
SQL
3 votes136 views1 answer
System.debug apex
SQL
23 votes142 views3 answers
Mysqldump
SQL
13 votes230 views6 answers
Mysql remove duplicates
SQL
13 votes177 views2 answers
Get tables in database sql
SQL
0 vote340 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL