MySQL server version for the right syntax to use near ';) T' at line 7
来源:互联网 发布:arcgis api for js 编辑:程序博客网 时间:2024/06/05 16:22
因为不仔细导致出现两次这个异常问题了,特此记录下!!!
check the manual that corresponds to your MySQL server version for the right syntax to use near ‘;) T’ at line 7
2017-06-22 15:15:58 [ERROR][qtp1190820921-24][PageHelper]-[setPageParameter] Ignore this exceptioncom.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 ';) T' at line 7 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
多了一个分号。。。有时候能执行查询成功,有时候不能,我勒个去!
阅读全文
0 0
- MySQL server version for the right syntax to use near ';) T' at line 7
- MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- your MySQL server version for the right syntax to use near 'NULL' at line 1
- MySQL server version for the right syntax to use near '-1.stu stu0_' at line 1
- MySQL server version for the right syntax to use near 'type = InnoDB' at line 25
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 7
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- You have an error MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 20
- MySQL server version for the right syntax to use near 'info where info.stu_id = 1' at line 1
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- corresponds to your MySQL server version for the right syntax to use near错误原因之一
- mysql报错:MySQL server version for the right syntax to use near 'type=InnoDB'
- mysql ignore 不能执行MySQL server version for the right syntax to use near ignore问题
- java MySQL server version for the right syntax to use near
- your MySQL server version for the right syntax to use near 'UNION '
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT’
- leetcode 442. Find All Duplicates in an Array
- python数据分析chapter2-3
- android端上传后台数据 string字符串拼接问题
- leetcode No236. Lowest Common Ancestor of a Binary Tree
- Vue2+VueRouter2+webpack 构建项目实战(三)配置路由,整俩页面先
- MySQL server version for the right syntax to use near ';) T' at line 7
- Leetcode 338. Counting Bits
- [Leetcode] 216. Combination Sum III 解题报告
- UVa442
- JDBC
- ASM AMDU工具使用
- 半路出家, 我的iOS自学之路-2-头文件, 属性, 引用计数, 协议, 类别, 类扩展
- async异步问题(waterfall、parallel、eachSeries、map、whilst)
- cglib动态代理实现