<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 前夜没有引号啊,为什么会出现引号呢?
请各位帮忙,多谢了
解决方案 »
- 解析xls文件,解析的总条数问题------急!急
- 经典项目管理书籍推荐《《你都看过了吗?说说你看过的?比比看?》》
- 为什么我的applet走到这里不往下执行了?
- jsp字符串转换为日期
- 象我这样写 连接 和 关闭 数据有问题吗?
- 开始学习Struts,求师傅一名...
- 一个struts自定义标签问题,请高手帮忙
- 高分求救:requestDispatcher.forward导致线程吊死(急急急)
- 初学RMI,问题多多!
- Struts问题:如何在Action中,返回到给调用它的JSP页面?
- 读取考勤机数据时,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