#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this i

mysql报错

#1055 - Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by

解决办法：1

 steps to success:

1. sudo vim /etc/mysql/conf.d/mysql.cnf

2. Scroll to the bottom of file Copy and paste

   [mysqld]sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

to the bottom of the file

3. save and exit input mode
4. sudo service mysql restart to restart MySQL.

Done!

2

mysql -u root -p
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

You might need sudo for the first step:

sudo mysql -u root -p

这是stackoverflow上的回答，解决了我的问题，顺便说一句，中国的社区真垃圾，回答的解决办法都是屁话