Error creating MySQL table

Question

I get an error when running the following create table:

CREATE TABLE Event (
    id      VARCHAR(10)         NOT NULL,
    title       VARCHAR(100),
    start_date  DATE            NOT NULL,
    end_date    DATE,
    description TEXT,
    url     VARCHAR(200),
    website     VARCHAR(200),
    location    VARCHAR(32)     NOT NULL;
    PRIMARY KEY (id),
    FOREIGN KEY (location) REFERENCES Location(id)
);

The error I get is this:

#1064 - 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 '' at line 9

I know that this error has to do with incompatibility with the syntax and the mysql version running, but I've checked every line and the syntax is correct according to the documentation. Am I missing something?

Thanks in advance for all your answers.

Jeremy Smyth · Accepted Answer · 2009-06-28 20:35:35Z

3

Try changing the semicolon on line:

 location    VARCHAR(32)             NOT NULL;

to a comma.

answered Jun 28, 2009 at 20:35

Jeremy Smyth

23.6k2 gold badges57 silver badges66 bronze badges

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

3 Comments

rogeriopvl Over a year ago

Damn, now I feel like a complete noob. How was I missing that out? Thanks :)

Jeremy Smyth Over a year ago

Usually happens to me when I've been staring at the screen for too long. Do you have any trees you can stare at for 5 minutes? :)

rogeriopvl Over a year ago

Well, it's night over here in Portugal, so I'll just stare at the moon :)

Collectives™ on Stack Overflow

Error creating MySQL table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related