syntax error in SQL statement (create table if not exists)

Question

CREATE TABLE IF NOT EXISTS ax_storage 
(PID INT NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(PID), 
 Playername VARCHAR(32), 
 Time INT(10), Type INT(6), 
 World VARCHAR(32);

What is wrong with this SQL statement?

Solution 1

You are missing to close a paranthesis at the end of the query

CREATE TABLE IF NOT EXISTS ax_storage 
(
    PID INT NOT NULL AUTO_INCREMENT, 
    PRIMARY KEY(PID), Playername VARCHAR(32), 
    Time INT(10), 
    Type INT(6), 
    World VARCHAR(32)
);  -- <- you were missing this one

Solution 2

you forgot ) in the end of query

  CREATE TABLE IF NOT EXISTS ax_storage (PID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(PID), Playername VARCHAR(32), Time INT(10), Type INT(6), World VARCHAR(32));

Comments

[Elembur]

Works, thanks for helping :)

[Fabio]

You are welcome dude!