Answers for "1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

SQL

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

Expression number 1 of select list is not in group by clause

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Posted by: Guest on June-27-2020

Source

Code answers related to "1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

Code answers related to "1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us