And this isn't my nose. This is a false one.

mysql出现Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggre错误的解决办法

mysql为5.7之前，则会默认启用ONLY_FULL_GROUP_BY SQL模式，在该模式下MySQL查询非HAVING条件或ORDER BY聚合操作在查
cndz 2023-07-15 20:10:31