这种错误一般都是sql语句编写错误导致了,可以把sql放到数据库里单独执行下看下能不能执行。我这个错误是因为我把 “DATE”写成了“DATA”导致的
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(join_tiem) as joinTime,
count(*) as userCount
from video_visito' at line 1
大致就是这个原因。查下sql就行了