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 'and d

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 'and d_descr = '??????'' at line 3

来源：4-2 动态 SQL 拼接(下)

qq_琉璃时间_0

2017-06-30 17:34

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 'and d_descr = '??????'' at line 3 为什么拿到的是几个问号？编码问题吗？求解决

写回答关注

1回答

qq_琉璃时间_0

2017-06-30 17:37:43

已经解决尴尬的sql语法错误！

0 0

通过自动回复机器人学Mybatis---基础版

微信公众号自动回复功能学习Mybatis，基础教程加案例实战方式学习

107412 学习 · 786 问题

查看课程

相似问题

select ID,COMMAND,DESCRIPTION,CONTENT from message where 1=1 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 'COMMAN

回答 3

your MySQL server version for the right syntax to use near 'COMMAND='??''

回答 2

The server encountered an internal error that prevented it from fulfilling this request.

回答 1

### Error building SqlSession. ### The error may exist in com/imooc/config/sqlxml/Message.xml

回答 5

org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in com/imooc/config/sqlxml/Command.xml

回答 3

打开慕课网App查看更多内容