<delete id="DELETE-PROJECT-COMMON-MEMBER-LIST" parameterClass="String">
delete research_members where project_id = #projectId#:VARCHAR and is_principal = '0'
</delete>
提示错误:
Check the DELETE-PROJECT-COMMON-MEMBER-LIST-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.exceptions.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 'where project_id = '5454761471293546528297197':VARCHAR and is_principal = '0'' at line 1 Caused by: com.mysql.jdbc.exceptions.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 'where project_id = '5454761471293546528297197':VARCHAR and is_principal = '0'' at line 1
我的程序在where 前夜没有引号啊,为什么会出现引号呢?
请各位帮忙,多谢了
delete research_members where project_id = #projectId#:VARCHAR and is_principal = '0'
</delete>
提示错误:
Check the DELETE-PROJECT-COMMON-MEMBER-LIST-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.exceptions.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 'where project_id = '5454761471293546528297197':VARCHAR and is_principal = '0'' at line 1 Caused by: com.mysql.jdbc.exceptions.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 'where project_id = '5454761471293546528297197':VARCHAR and is_principal = '0'' at line 1
我的程序在where 前夜没有引号啊,为什么会出现引号呢?
请各位帮忙,多谢了
解决方案 »
- 大家总结下jsp、servlet及其自己之间参数传递方式
- response.getOutputStream()好像是没有关闭
- 查找可以下载《传智播客巴巴运动网106后视频》的信息??
- spring中log4j的配置问题
- 动态验证框架
- RMI是一种什么技术?
- 关于程序 io 异常: Size Data Unit (SDU) mismatch的错误!!!!
- tomcat不够稳定吗?
- jb9+weblogic:t3协议??
- EJB与JavaBean的区别何在?--今天就结帖
- 读取考勤机数据时,Can't get object clsid from progid
- DataSource datasource = getDataSource(request,"dataSources");报错
delete research_members where project_id = #projectId# and is_principal = '0'
改后的完整错误信息是啥?
delete research_members where project_id = '5454761471293546528297197':VARCHAR and is_principal = '0'先把这条SQL放SQLyog里执行下看通不通再说吧,不通就百度,谷歌.. 通之
然后你再改对应的SQL就没问题了
check the manual that corresponds to your MySQL server version for the right syntax to use near 'where project_id = '5454761471293546528297197' and is_principal = '0''
声明:我用的是ibatis连接mysql