Answers for "remove only_full_group_by from mysql query"

SQL
1

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
Posted by: Guest on May-12-2021

Code answers related to "remove only_full_group_by from mysql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language