/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 votes202 views2 answers
Mysql select where starts with
SQL
0 vote239 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
6 votes216 views2 answers
Postgresql pg_dump
SQL
0 vote219 views1 answer
Plsql check how much space all databases are consuming
SQL
5 votes222 views4 answers
Traduction
SQL
0 vote222 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote244 views1 answer
Difference berween database and data base management system
SQL
0 vote210 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote206 views1 answer
Test database for sql
SQL
0 vote216 views1 answer
How to move a column to different spot mysql
SQL