Answers for "Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

1

Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column

#enter the command below
find / -name my.cnf

#your should find something like
#/etc/mysql/my.cnf

#edit the file
sudo nano /etc/mysql/my.cnf
#add the 2 lines of command below and save

[mysqld]
sql_mode = ""

#restart mysql
systemctl restart myqsl
Posted by: Guest on October-18-2021

Code answers related to "Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

Code answers related to "Javascript"

Browse Popular Code Answers by Language