/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

7 votes257 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote256 views1 answer
Mysql create pool
SQL
0 vote287 views2 answers
Clauses in mysql
SQL
1 vote257 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote238 views1 answer
How to get inserted id in sql server
SQL
0 vote269 views1 answer
Hoq to import database source
SQL
0 vote273 views1 answer
Get who is hired in february in sql
SQL
7 votes252 views1 answer
Connect mysql docker
SQL
0 vote261 views2 answers
Plsql regex match whole word
SQL
26 votes258 views2 answers
Mysql workbench download
SQL