mysql建表的问题 表明要叫table该如何命名？
本帖最后由 uranometria 于 2020-10-22 11:35 编辑create table Order(
OrderID int,
Name varchar(20),
Orderdate date ,
Store varchar(20),
Product varchar(20),
Quantity int,
Amount int,
primary key(Product)
);
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(
OrderID int,
Name varchar(20) ,
Orderdate date' at line 1{:10_266:}
发现是名字引起的错误..但是想要写成order改如何命名呢？ 不能用关键字命名
页:
[1]