/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

6 votes190 views5 answers
Alter table oracle
SQL
-1 vote180 views1 answer
How to format tables in sqlplus
SQL
0 vote379 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote193 views1 answer
How to add session data into mysql database from button
SQL
4 votes216 views3 answers
Employee name starting with in sql
SQL
1 vote193 views1 answer
Add time to date sql
SQL
0 vote180 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
2 votes243 views3 answers
Mysql unix timestamp to date
SQL
0 vote226 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote203 views1 answer
Mysql dump for selected row
SQL