问题描述

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

解决方案

关于在myeclipse中执行mySQL语句出现问题
mysql++安装出现问题
python 连接mysql 出现问题

解决方案二：

已经提示了呀，这个：where t.id=o.userid**'10e58a7c47624a999b400028b25b5f2f'** and t.acco_date........ 这个地方是怎么回事啊

解决方案三：

同上，提示说where t.id=o.userid**'10e58a7c47624a999b400028b25b5f2f'** and t.acco_date........ 有语法错误啊