mysql语句出现数据库出现问题
PreparedStatementCallback; bad SQL grammar [select (select name from vs_base_orga where id=(select pid from vs_base_orga where id=o.orgaid )) as orga_name ,(select name from vs_base_orga where id=o.orgaid )as depart_name,sum(t.acco_should)as acco_should,sum(t.acco_provide)as acco_provide,sum(t.acco_accumulation)as acco_accumulation,sum(t.acco_medical)as acco_medical,sum(t.acco_unemployment)as acco_unemployment,sum(t.acco_person)as acco_person,sum(t.acco_deductions)as acco_deductions,sum(t.acco_other_sub)as acco_other_sub,sum(t.acco_actual)as acco_actual,(t.acco_date)as acco_datefrom vs_base_oum o,tc_account t where t.id=o.userid'10e58a7c47624a999b400028b25b5f2f' and t.acco_date >='2015-11-01' group by orga_name,depart_name']; nested exception is 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 'vs_base_oum o,tc_account t where t.id=o.userid'10e58a7c47624a999b400028b25b5f2f'' at line 1
推荐阅读
-
使用wordpress的$wpdb类读mysql数据库做ajax时出现的问题该如何解决
-
MySQl数据库必知必会sql语句(加强版)
-
MySQL数据库基本语句展示
-
常用的Mysql数据库操作语句大全整理
-
在CMD中操作mysql数据库出现中文乱码解决方案
-
mysql安装出现问题(The service already exists)
-
Mysql查询语句使用select.. for update导致的数据库死锁分析
-
MySQL数据库的隔离级别之可重复读为什么能够有效防止幻读现象的出现
-
解决mysql创建数据库后出现:Access denied for user 'root'@'%' to database 'xxx'的问题
-
使用JDBC连接Mysql数据库会出现的问题总结