在项目开发过程中Eclipse出现了这样一个错误，遇到过几次了，感觉这个问题比较常见，所以贴出来与大家分享下
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 'desc, statusstr, statusdesc, purpose, createdate) values ('201308300001', '?°?è?' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
解决方案： 检查Mysql数据库中是否使用了关键字，我报这错误是应为使用了 desc关键字，后来改了个字段名,马上好了,看来命名不严谨啊，哈哈~~
相关推荐
check the manual that corresponds to your MySQL server version for the right syntax to use near ‘order’ at line 1 数据库报错如下： Error querying 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 ‘(0) NOT NULL, endTime datetime(0) NOT NULL,avaliableTime int(8) ...
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 'identified by 'password' with grant option' mysql 5和mysql 8都有...
mysql_exporter消除了"Error 1064 (42000): 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 'SLAVE STATUS' at line 1...
### The error occurred while setting parameters ### SQL: SELECT * FROM Domain_System WHERE domain = ? LIMIT 1 ### Cause: ...
本文实例讲述了mysql报错：...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 ‘type=InnoDB’ at line 1 二、解决方案
前几天帮同事解决一个案例，在主从复制环境下，从库上的MySQL版本号是5.5.5，... Last_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for t
check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqltump -u root -p sa > D:/sa.sql' at line 1 原因：mysqldump是mysql用于转存储数据库的实用程序并不是...
mysqldump: Couldn’t execute ‘SET OPTION SQL_QUOTE_SHOW_CREATE=1’: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio····这句话对于咱们并不陌生，无非就是多了“，”之类的问题。但是你如果无意之中添加了一个mysql中的...
check the manual that corresponds to your MySQL server version for the right syntax to use near ‘`company_id` int) RETURNS varchar(20) CHARSET utf8 BEGIN 本来的函数： CREATE DEFINER=`33323`@`%` ...
在搭建springmvc框架时，底层使用... 代码如下:[13-04-13 19:11:37.190] {resin-60} You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synt
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. 解决方法 解决该问题有两种方法：一种是使用替换法，另一种是使用 PreparedStatemenc 对象...
命令成功执行。操作发生错误，相关的信息为... Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘old_password(‘123456′)’ at line 1命令为：set password for
check the manual that corresponds to your MySQL server version for the right syntax to use near '...' at line X"，提示SQL语句中的语法错误，需要检查并修正语句。 7. 错误代码1452: "Cannot add or update...
check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 MySQL Errno : 1064 Message : MySQL Query Error 在未修复栏目前，添加信息出错的问题。...
check the manual that corresponds to your MySQL server version for the right syntax to use near 'showtabxx' at line 1 ``` 此时，如果用户使用`Ctrl+C`，错误的命令并不会被撤销，MySQL会提示语法错误，...