java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for

最新推荐文章于 2024-08-16 16:30:26 发布
最新推荐文章于 2024-08-16 16:30:26 发布
阅读量8.4k 收藏
点赞数
分类专栏： 数据库 问题汇总 WEB相关 文章标签： sql server mysql c
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ja_II_ck/article/details/2905633
版权
WEB相关 同时被 3 个专栏收录
19 篇文章 0 订阅
订阅专栏
问题汇总
18 篇文章 0 订阅
订阅专栏
数据库
14 篇文章 0 订阅
订阅专栏

java.sql.SQLException: 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 '宋体'" vAlign="top" align="left" width="473" bgColor="#f7e4c3">
<P style="PADDI' at line 1

 

插入的字符串中有下面一段代码：

 <td width="473" align="left" valign="top" bgcolor="#F7E4C3" style="font-size:12px; color:#2d2e2e; font-family:'宋体'; line-height:200%">

 

 估计是由于没有对插入的字符进行过滤，所以在遇到单引号时导致SQL语句结构错误。因为在此前的代码中都是双引号，未出现过单引号。

 

最后证实的确是字符未过滤的问题，在后来的开发过程中屡次出现类似问题，过滤掉非法字符就OK了。 

 

 

ja_II_ck
关注
专栏目录
全网多种方法解决You have an error in your SQL syntax； check the manual that corresponds to your MySQL server
念兮为美
04-13 3万+
全网多种方法解决java.sql.SQLSyntaxErrorException: 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 'xxx ) VALUES(xxx)' at line 1
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the manual
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
04-19 4573
sql语法报错
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
游海东的技术专栏
08-30 2089
1、错误描述org.hibernate.exception.SQLGrammarException: error executing work at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80) at org.hibernate.except
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to yo
liuyishou
06-28 2万+
java报语法问题，除了市面上那些普通的回答之外，还有一个caodan的原因，如下： 额外踩过的坑及总结： 经验：对了，在java开发中，想要快速的找到bug一个很好的办法就是将两段基本一样的代码进行对比，不断简化，最钟就是在saibi的问题也能找到。 另外，我的eclipse真滴无语，由于各种版本的问题（eclipse版本，mysql版本，c3p0版本），在javase的...
解决 SQL错误 [1064] [42000]: You have an error in your SQL syntax； check the manual that corresponds to
最新发布
chenduo_CD的博客
08-16 304
图中错误产生的原因：最后一行）这个括号前面不能有空格。
解决You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versi...
weixin_30507269的博客
03-03 255
在学习hibernate一对多映射关系时，根据视频学习的时候，例子是顾客和订单的问题，一个顾客有多个订单。按照视频中的敲代码出现了You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n...
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s...
weixin_34117522的博客
07-16 1万+
[Err] 1064 - 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 ''&amp;lt;h1 style=&amp;quot;text-align: center;&amp;...
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the manual that corre
weixin_45602720的博客
12-09 2095
java.sql.SQLSyntaxErrorException: 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 'check,deleted,create_by,create_time,update_by,update_time FROM xxx MySQL数据库字段 不能用chec
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
11-04 4003
java.sql.SQLSyntaxErrorException: 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 '（USER_NAME，USER_PASSWORD） VALUE...
ava.sql.SQLException: 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 '201' at line 1 Query: drop table 201 Parameters: []
06-07
It seems that you are trying to drop a table named "201", but the SQL engine is throwing an error due to a syntax issue. In MySQL, table names cannot start with numbers, so this could be the root ...
java.sql.SQLSyntaxErrorException: 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 '?, ?)' at line 1出现这种错误怎么办
06-07
这个错误信息提示您的SQL语法存在问题，可能是由于占位符的设置不正确导致的。请确保您在使用PreparedStatement时，正确地设置了占位符并将其替换为实际的值。 首先，您需要检查您的SQL语句是否正确。在这种情况下...
JavaWeb错误:You have an error in your SQL syntax； check the manual that corresponds to your MySQL
weixin_45906199的博客
01-24 584
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 ‘10’ at line 1 您的SQL语法有错误；请检查与您的MySQL server版本对应的手册，以获取第1行“10”附近要使用的正确语法 原因sql语句拼接错误:仔细检查看看自己拼接的sql语句 忘记加逗号了!!! ...
java.sql.SQLException: You have an error in your SQL syntax； check the manual that corresponds to yo
m0_63309946的博客
08-11 1778
自己在数据库中原来使用的是order作为表名，而order是mySQL数据库系统的关键字，所以才会一直报语法错误，后面才改为orders为表名，别忘记在代码里也需要修改哦，这里希望大家不要入这个坑，希望给大家带来帮助，有喜欢的小伙伴可以关注下，后续也会继续更新！今天踩了一个坑，报这种错误首先你可能会想到先去检查自己的SQL有没有写错，如果发现自己的SQL语句没有写错，那么就要注意了！......
Java SQLSyntaxErrorException: You have an error in your SQL syntax问题4种情况解决(SQL、JPA、MyBatis)
旭东怪的博客
02-03 2万+
问题描述： Caused by: java.sql.SQLSyntaxErrorException: 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 'insert into t_salary_2021_01( DETAILID) values('52dd5ce4a5794573b9b20
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
weixin_34195364的博客
11-11 193
Caused by: 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 righ...
错误信息:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve
夙玮
12-05 2620
错误信息: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 ” at line 1 mysql_query("set names 'GBK'");
ER_PARSE_ERROR: You have an error in your SQL syntax check the manual that corresponds to your MySQL
热门推荐
Talk is cheap
01-07 8万+
update job_info set require = 'XXXX' where id= 123 在mysql执行上面的代码一直报下面的异常： throw err; // Rethrow non-MySQL errors         ^ Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the
You have an error in your SQL syntax； check the manual that corresponds to your MySQL server version
Xander_He的博客
08-20 262
新接个项目结果表查询报错：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 'system' at line 1 排查发现mysql 表查询要加上 ` 不是单引号。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值