/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

2 votes263 views1 answer
How to check grants on a package in oracle
SQL
13 votes206 views5 answers
Sql default
SQL
1 vote200 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote215 views1 answer
Sql delimiter to columns
SQL
1 vote207 views1 answer
Best configuration for display table in sqlplus
SQL
12 votes243 views6 answers
How to install sqlite3 in python
SQL
0 vote190 views1 answer
Check if record exists mysql
SQL
0 vote198 views2 answers
How to count codition
SQL
3 votes188 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote278 views1 answer
How many rows affected in sqllite
SQL