I'm trying to create a table via some godforsaken web interface-type thing that churns out this...stuff, and...
Basically, I'm used to SQLserver, not mySQL and could somebody please tell me what the syntax error is that it keeps bleating on about in the below statement?
CREATE TABLE forum_posts (id INT (4) UNSIGNED not null AUTO_INCREMENT, post_date DATETIME (12) DEFAULT 'NOW()' not null , user_id INT (4) not null , message TEXT (16) not null , PRIMARY KEY (id), INDEX (id), UNIQUE (id))
For date and time types other than TIMESTAMP, the default is the appropriate zero value for the type. For the first TIMESTAMP column in a table, the default value is the current date and time. See section 6.2.2 Date and Time Types.