You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
来源:互联网 发布:朱高煦 知乎 编辑:程序博客网 时间:2024/06/18 10:46
偶遇一朋友的一个bug,这个朋友在设计数据库的时候将表名设置成了一个关键字“group”,在后期的编程中遇到了这个问题。
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 'group limit 0,5' at line 1
报错代码:
String sql = "select * from group limit ?,?";
解决措施:1` 更改表名;
2` 需要把 group 用撇号`括起来,就是键盘上数据1左边的那个键.
阅读全文
1 0
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
- *You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
- ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- MySql-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versi
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- 错误信息:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- Android Things SDK用法之PIO篇
- 基于模型的PLC程序设计二 启保停电路
- A* 算法解决八数码问题 matlab
- Android Retrofit 2.0(二)使用教程OkHttp3 + Gson + RxJava
- Github使用(1)-GitHub Desktop下载及使用
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio
- strcat函数简单例子详解
- 【leetcode】35. Search Insert Position
- 物理地址、虚拟地址和逻辑地址之间的区别
- 递归求鸭子数
- 智能仓储 和 智能物流中的人工智能技术
- 静态链表
- winform只允许单个运行
- 五个选择LunarBase的理由