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
上一篇: 如何学习框架和模板!
下一篇: Photoshop 一张潮流风格手枪插画
推荐阅读
-
Linux安装MySQL后找不到my.cnf原因以及从sql语句文件恢复数据库_MySQL
-
6条比较有用的MySQL数据库操作的SQL语句小结
-
lamp-编译安装mysql出现问题,求大神指点
-
CI框架出现mysql数据库连接资源无法释放的解决方法,cimysql_PHP教程
-
MySQL数据库出现The server quit without updating PID file._MySQL
-
数据库菜鸟不可不看 简单SQL语句小结_MySQL
-
mysql常用语句练习-基于ecshop2.7.3数据库(1)
-
mysql-在配置mySQL主从复制 出现问题
-
在MySQL数据库中使用C执行SQL语句
-
mysql数据库中sql语句有关问题