ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
来源:互联网 发布:张爱玲霸王别姬知乎 编辑:程序博客网 时间:2024/04/25 00:31
ERROR: 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 (
ORDER_ID integer not null auto_increment,
ORDER_NAME var' at line 1
ERROR: 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
add index FK_p1xf4mmtq806hthtu6mxv2tf0 (CUSTOMER_ID),
ad' at line 1
第一个错误:在我的SQL 语法中,检查到对于MySQL 的使用出错(ORDER_ID 没有被增长, ORDER_NAME 没有被定义,在第一行)
第二个错误:在我的SQL 语法中,检查到对于MySQL 的使用出错(添加索引 FK_p1xf4mmtq806hthtu6mxv2tf0 (CUSTOMER_ID), 在第一行)
说明数据库表在被创建的第一步出错, 后来检查到我的数据库表名为 Order、 为 关键字=.= 在Order后面加个s,改为Orders
问题解决了!!!
0 0
- 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
- 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 versio
- 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 versio
- java实现拷贝文件到另一个路径
- Mongodb journal与oplog,究竟谁先写入?
- Android二维码之zxing
- Makefile学习笔记<变量的高级用法>
- Android获取assets文件夹下的json数据,并解析!
- ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- 关于Android自己应用跳转地图APP
- weblogic注册服务
- instanceof 的意思和使用
- iOS GPUimageCamera锁屏崩溃解决方法
- Codeforces 792D Paths in a Complete Binary Tree 规律+模拟
- Shader代码重复利用
- node 学习笔记
- jboss7.1 在modules中引入其他jar包