首页  >  文章  >  数据库  >  mysql语句出现数据库出现问题

mysql语句出现数据库出现问题

WBOY
WBOY原创
2016-06-06 09:35:571513浏览

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

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn