title: MySQL syntax error in the CREATE TABLE statement
body: <p>SQL query:</p>
  
  <pre><code>CREATE TABLE  `comment_threads` (
   `comment_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0',
   `updated` TIMESTAMP NOT NULL ,
   `timestamp` TIMESTAMP NOT NULL ,
  ) ENGINE = MYISAM ;
  </code></pre>
  
  <p>This is an old file that I'm trying to run on HostGator through phpMyAdmin. I get an error that says:</p>
  
  <blockquote>
    <p>MySQL said: #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 ') ENGINE=MyISAM' at line 5</p>
  </blockquote>
  
  <p>UPDATE:
  If I change the statement to this, I still get an error:</p>
  
  <pre><code>CREATE TABLE comment_threads (
  comment_id INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
  updated TIMESTAMP( 14 ) NOT NULL ,
  timestamp TIMESTAMP NOT NULL
  PRIMARY KEY ( comment_id ) )
  ENGINE = MYISAM ;
  </code></pre>
  
  <p>I get the error:</p>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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 '( 14 ) NOT NULL ,
    timestamp TIMESTAMP NOT NULL
    PRIMARY KEY ( comment_id ) )
    ENGI' at line 3</p>
  </blockquote>