错误原因:在MySQL5.7之后,sql_mode 默认会有 ONLY_FULL_GROUP_BYSQL语句未通过ONLY_FULL_GROUP_BY语义检查所以报错此参数 ( ONLY_FULL_GROUP_BY ) 要求select, insert,update, delete 等语句中查询出来的列必须是明确的解决办法:1.执行SQL语句SELECT @@sql_mode2.得到查询结果:ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_A...