Where is the error in my query?

Question

I wish I could give you more information from my investigation into the error, but the most descriptive info I get is "You have an error in your SQL syntax".

CREATE TABLE jobs (
    id MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR (200), 
    descshort VARCHAR (400), 
    descr VARCHAR (7000), 
    postdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

Answer 1

I guess you have an error in your SQL Syntax. You forgot the closing ")"

CREATE TABLE jobs (
    id MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR (200), 
    descshort VARCHAR (400), 
    descr VARCHAR (7000), 
    postdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

Answer 2

You are missing a closing bracket.