mysql建表的问题 表明要叫table该如何命名？

uranometria

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


发现是名字引起的错误..但是想要写成order改如何命名呢？

一枚丶学渣

不能用关键字命名