mysql5.7 group by

weixin_30535565

于 2019-08-09 14:33:00 发布

阅读量113

点赞数

原文链接：http://www.cnblogs.com/thymeleaf/p/11327006.html

版权

2019-08-09 11:12:29.043 WARN 12572 --- [io-9612-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1055, SQLState: 42000 2019-08-09 11:12:29.043 ERROR 12572 --- [io-9612-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper : #42000 2019-08-09 11:12:29.059 ERROR 12572 --- [io-9612-exec-10] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [/api] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause

解决方案我这里用临时解决一下
set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
当然了这个治标不治本，还是去配置文件里改动吧

转载于:https://www.cnblogs.com/thymeleaf/p/11327006.html