mysql-8.0.13 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colum

mysql 执行错误，如下sql

SELECT
	* 
FROM
	( SELECT * FROM ( SELECT * FROM student ORDER BY gmt_modified DESC LIMIT 9999 ) b GROUP BY s_no ) c 
WHERE
	1 = 1 
ORDER BY
	gmt_modified DESC

解决方式：

• Windows:
  打开安装根目录的my.ini配置在[mysqld]加入sql=...，如下配置

[mysqld]
# 数据库兼容配置
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

• Linux
  编辑配置文件： vim /etc/mysql/conf.d/my.cnf，同windows一样

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

执行:wq保存退出~