在项目开发过程中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关键字，后来改了个字段名,马上好了,看来命名不严谨啊，哈哈~~
相关推荐
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) ...
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用于转存储数据库的实用程序并不是...
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都有...
### 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
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 ‘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 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 'identified by "12345678"' at line 1 的错误，原因是新版本mysql版本把将创建账户和赋予权限分开了。 ...