MySQL syntax error...don't understand why

Question

I'm very very new to MySQL/SQL. I'm trying to create a database with a couple of tables. The first few tables created just fine, but this last one is giving me trouble. Here's what I am doing:

mysql> CREATE TABLE Order (                                                    
-> CustomerId INTEGER NOT NULL,                                                 
-> EmployeeId INTEGER,
-> Id INTEGER,
-> DT DATETIME(),
-> PRIMARY KEY (Id),
-> );

I am presented with this error:

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 (
CustomerId INTEGER NOT NULL,
EmployeeId INTEGE' at line 1

Any ideas?

Thank you :)

`ORDER` is a reserved keyword. Maybe use another name `Orders`? — Dhruv Saxena, Mar 04 '17 at 22:23

score 0 · Answer 1 · answered Mar 04 '17 at 22:35

Take the , off the end:

mysql> CREATE TABLE Order (                                                    
-> CustomerId INTEGER NOT NULL,                                                 
-> EmployeeId INTEGER,
-> Id INTEGER,
-> DT DATETIME(),
-> PRIMARY KEY (Id)
-> );

score -1 · Answer 2 · answered Mar 04 '17 at 22:23

-1

I think because Order is a keyword try wrapping it in []s, or pick another name.

answered Mar 04 '17 at 22:23

Mike Hankey

17
7

`[]`s are not [MySql quote characters](https://dev.mysql.com/doc/refman/5.7/en/identifiers.html). – GSerg Mar 05 '17 at 10:45

MySQL syntax error...don't understand why

2 Answers2