MySQL - CREATE TABLE - Syntax Error - Error 1064

Question

I have been looking at the below sql script for ages now and I can't see the problem! It's getting error 1064 - which could be anything...

CREATE TABLE order (order_no INTEGER NOT NULL AUTO_INCREMENT,
                vat_id INTEGER NOT NULL,
                order_status VARCHAR(30) NOT NULL,
                order_pick_date DATE,
                order_ship_from INTEGER NOT NULL,
                employee_id INTEGER NOT NULL,
                payment_id INTEGER,
                PRIMARY KEY (order_no))
        ENGINE = MYISAM;

BrianAtkins · Accepted Answer · 2015-04-21 22:31:12Z

1

Order is a reserved word in SQL, pick a different name for your table.

answered Apr 21, 2015 at 22:31

BrianAtkins

1,3599 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nathan English Over a year ago

Thanks for that - it's so easy to look at these things for hours and miss the obvious!

Matt · Accepted Answer · 2015-04-21 22:45:49Z

1

The problem is that you are trying to create a table using a reserved name. If you change the table name to 'orders' then it will work.

Have a look at https://dev.mysql.com/doc/refman/5.5/en/reserved-words.html for the full list of reserved words.

answered Apr 21, 2015 at 22:45

Matt

901 silver badge8 bronze badges

Comments

Uours · Accepted Answer · 2015-04-21 23:59:14Z

1

As others have already pointed , the reserved word order is the issue .

However if you need to , you can still use it by enclosing with backticks / backquotes :

`order`

The corrected SQL statement ( which worked for me in MySQL 5.5.24 ) is :

CREATE TABLE
`order`
(
     order_no INTEGER NOT NULL AUTO_INCREMENT
    ,vat_id INTEGER NOT NULL
    ,order_status VARCHAR(30) NOT NULL
    ,order_pick_date DATE
    ,order_ship_from INTEGER NOT NULL
    ,employee_id INTEGER NOT NULL
    ,payment_id INTEGER
    ,PRIMARY KEY (order_no)
)
ENGINE = MYISAM;

edited Apr 21, 2015 at 23:59

answered Apr 21, 2015 at 23:24

Uours

2,4921 gold badge19 silver badges21 bronze badges

Collectives™ on Stack Overflow

MySQL - CREATE TABLE - Syntax Error - Error 1064

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related