【MySQL更新的几个异常记录】教程文章相关的互联网学习教程文章

mysql 5.7版本异常Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 处理【代码】

今天在做按时间分组统计数据时,一段sql在数据库运行正常,但是在java代码中抛出了异常: sql语句: SELECT DATE_FORMAT( commitTime, '%H' ) AS gjtime , COUNT(1) AS gjsum FROM jenkins_data GROUP BY gjtime ORDER BY commitTime DESCjava 抛出的异常信息: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column不明所以,网上也给出了很多的处理方法,修改my.cnf,这类的居多,但也...