title: Syntax error when running a MySQL CREATE TABLE statement
body: <pre><code>CREATE TABLE users (
  user_id     INT(8) NOT NULL AUTO_INCREMENT,
  user_name   VARCHAR(30) NOT NULL,
  user_pass   VARCHAR(255) NOT NULL,
  user_email  VARCHAR(255) NOT NULL,
  user_date   DATETIME NOT NULL,
  user_level  INT(8) NOT NULL,
  UNIQUE INDEX user_name_unique (user_name),
  PRIMARY KEY (user_id)
  ) TYPE=INNODB;
  </code></pre>
  
  <p>When running this query on the SQL server, I am getting the following error:</p>
  
  <pre><code>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 'TYPE=INNODB' at line 10
  </code></pre>
  
  <p>Any help on why this is coming up?</p>