Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL synt

 这种错误一般都是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就行了