Error querying database. Cause: java.sql.SQLSyntaxErrorException: 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 'select count(1) from xg_teacher_leave where user_id = a.user_id and examination_' at line 34
Cause: java.sql.SQLSyntaxErrorException: 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 'select count(1) from xg_teacher_leave where user_id = a.user_id and examination_' at line 34\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: 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 'select count(1) from xg_teacher_leave where user_id = a.user_id and examination_' at line 34
这是统计的一个字段,如上所示运行一直报错。后来在qjcs前加个空格就好了。