mysql> use test;
Database changed
mysql> CREATE TABLE Order
-> (
-> number INTEGER,
-> shippingAddress varchar(100),
-> shippingDate varchar(100),
-> orderID Integer NOT NULL,
-> orderLineItemID Integer,
-> PRIMARY KEY (orderID)
-> )
-> ;
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 'Order(
number INTEGER,
shippingAddress varchar(100),
shippingDate varchar(10' at line 1
mysql>
不知道为什么?有人帮我解答下吗??
Database changed
mysql> CREATE TABLE Order
-> (
-> number INTEGER,
-> shippingAddress varchar(100),
-> shippingDate varchar(100),
-> orderID Integer NOT NULL,
-> orderLineItemID Integer,
-> PRIMARY KEY (orderID)
-> )
-> ;
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 'Order(
number INTEGER,
shippingAddress varchar(100),
shippingDate varchar(10' at line 1
mysql>
不知道为什么?有人帮我解答下吗??
-> (
-> number INTEGER,
-> shippingAddress varchar(100),
-> shippingDate varchar(100),
-> orderID Integer NOT NULL,
-> orderLineItemID Integer,
-> PRIMARY KEY (orderID)
-> );
Query OK, 0 rows affected (0.14 sec)mysql>
-> (
-> `number` INTEGER,
-> shippingAddress varchar(100),
-> shippingDate varchar(100),
-> `orderID` Integer NOT NULL,
-> orderLineItemID Integer,
-> PRIMARY KEY (`orderID`)
-> )
-> ;
order 是保留字,需要用反引号标识 `