/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

-1 vote129 views1 answer
How to format tables in sqlplus
SQL
1 vote140 views1 answer
Simple project for database
SQL
0 vote151 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
16 votes133 views1 answer
Sqlserver add column to table
SQL
1 vote178 views1 answer
Oracle check table lock
SQL
3 votes162 views1 answer
Force using index oracle
SQL
1 vote147 views1 answer
Type int in mysql maxlenght
SQL
19 votes136 views2 answers
Mysql add column after another
SQL
7 votes148 views3 answers
Convert ansi sql
SQL
5 votes154 views1 answer
Mysql last day of next month
SQL