MySQL 5.6 Command line client create table 1064 error

Question

Trying to create simple table in sql:

CREATE TABLE order (username VARCHAR(20), productid INT, count INT, orderdate VARCHAR(30), price INT);

But i got ERROR 1064 (42000) (syntax).

score 0 · Answer 1 · answered Nov 29 '14 at 16:46

0

order is a reserved word and needs to be escaped with backticks. Or use a different name for your table like orders

CREATE TABLE `order` (...

answered Nov 29 '14 at 16:46

juergen d

score 0 · Accepted Answer · answered Nov 29 '14 at 16:55

Try this:

CREATE TABLE _order (username VARCHAR(20), productid INT, count INT, orderdate VARCHAR(30), price INT);

order is a reserved word of mysql. So you cant use it. Refer to this guide. This would help you.

2 Answers2