MySQL遇到check the manual that corresponds to your MySQL server version for the right syntax错误

最新推荐文章于 2021-10-04 14:58:50 发布
最新推荐文章于 2021-10-04 14:58:50 发布
阅读量154 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/zzxbest/archive/2011/09/22/2185029.html
版权

用MySQL新建了一个Order表，插入了一条数据。总是显示

 

 

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 'order
' at line 1

 

 

 的错误，开始还以为是mysql什么版本的问题。用Navicat for MySQL查看里面也是有数据的，这是神马原因呢。找了半天将表名改成了t_order，里面类似关键字的字段也进行了重命名结果就OK了。

 

原来是MySQL表中不能包含关键字啊。。。一个小疏忽害得我晕了半天

转载于:https://www.cnblogs.com/zzxbest/archive/2011/09/22/2185029.html

weixin_30511107
关注
check the manual that corresponds to your MySQL server version for the right syntax to use完美解决
计算机毕业论文源码，学生个人网页制作html源码。贴近用户做网络推广和互联网优化。
09-02 17万+
check the manual that corresponds to your MySQL server version for the right syntax to use near方法有六个： 1、在数据库表冲突字段前后加 `符号(键盘Tab键上面那个键)，就不会再报语法错误了； 2、修改数据库表中冲突字段名称，修改为和 SQL语句关键字不冲突的其他名称。 3、navicat工具不可以，命令行可以。 check the manual that corresponds to your MySQ
check the manual that corresponds to your MySQL server version for the right syntax to use near 解决方法
最新发布
码农研究僧的博客
06-10 2924
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 ') NULL COMMENT '实际工时' AFTER 'expected_work_time' at line 2
check the manual that corresponds to your MySQL server version for the right syntax
weixin_40460171的博客
06-26 374
完整报错 Error updating database. Cause: 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 'insert into t_user_rol.
check the manual that corresponds to your MySQL server version for the right syntax错误
热门推荐
hello__word__的博客
07-29 14万+
check the manual that corresponds to your MySQL server version for the right syntax to use near 'Order (moneys, orderNumber) values (0.0, 'A001')'错误
MySQL check the manual that corresponds to your MySQL server version for the right syntax错异常解决方法
u011394172的专栏
02-11 653
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 '8 * from t_admin' at line 1
MySQL出现check the manual that corresponds to your MySQL server version for the right异常
10年职场两茫茫，35岁凄凉奈若何
08-31 360
MySQL出现check the manual that corresponds to your MySQL server version for the right异常
check the manual that corresponds to your MySQL server version for the right syn
zfjdoreen的专栏
11-19 166
错误：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 'not null, add column username varchar not null' at line 1 原...
corresponds to your mysql server version_check the manual that corresponds to your MySQL server vers...
weixin_29415575的博客
02-01 418
09:22:13,706 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1064, SQLState: 4200009:22:13,707 ERROR org.hibernate.util.JDBCExceptionReporter:101 - You have an error in your SQL syntax...
mysql报错：MySQL server version for the right syntax to use near type=InnoDB的解决方法
01-21
本文实例讲述了mysql报错：MySQL server version for the right ... check the manual that corresponds to your MySQL server version for the right syntax to use near ‘type=InnoDB’ at line 1 二、解决方案
postman运行时返回 check the manual that corresponds to your MySQL server version for the right syntax to.
zhen_hh的博客
10-04 1185
报错信息如下： Error updating database. Cause: 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 ‘‘name’,‘state’,‘country’) values(‘mmmm’,‘aaa’,
JAVA中 Mysql错误:check the manual that corresponds to your MySQL server version for the right syntax
lmxmyy的博客
02-09 1万+
反复检查过多次语句都没发现错误，后来网上搜索解决方法见到：数据库表字段与SQL关键字冲突导致的错误 错误信息为：check the manual that corresponds to your MySQL server version for the right syntax 这是之前写的一条 Mysql语句报的 SQL错误，但是仔细检查 SQL语句没有发现有什么异常问题。后来百度查到，我的...
遇到的check the manual that corresponds to your MySQL server version for the right syntax错误
风起于青萍之末，折秀于林
07-29 906
遇到这种问题，十有八九是 创建的表名中某些字段包含了mysql的关键字，或者插入的值中出现了某些关键字。
check the manual that corresponds to your MySQL server version for the right syntax to use near报错处理
yuanyouhui12345的博客
05-08 350
用datax抽取mysql的数据报错： check the manual that corresponds to your MySQL server version for the right syntax to use near 'explain,0x09,''),0x0a,''),0x0d,''),REPLACE(REPLACE(REPLACE(phone,0x09,''),0x0a,'' ...
MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
永不止步！！！！
06-04 1818
百度说 关键字冲突。。我就把字段名全改了，还是不行。。。 原来是表名order和mysql关键字冲突。换了个名字就好了。
MySQL异常 check the manual that corresponds
梦凝哲雪
09-24 7647
向数据库中表中插入数据时候 一直报错 无法插入成功 信息 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 'order(oid,create_time,oprice,ostatus,mid)values('16009113129672','2
check the manual that corresponds to your MySQL server version for the right syntax处理方案
weixin_30596735的博客
11-12 59
check the manual that corresponds to your MySQL server version for the right syntax:代码出现这样的bug，就要注意你的数据库字段是否出现和SQL关键字冲突的，比如“desc”、"order"这些，之前在大学遇到过这种bug，调试了很久才发现 转载于:https://www.cnblogs.com/mzq123/p...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值