title: MySQL syntax error when specifying innodb database type and character set
body: <p>I cant seem to import my tables.sql to a database called callumba_login. Here is the SQL:</p>
  
  <pre><code>CREATE TABLE Country(
      country_code                char(2) not null,
      country_name                varchar(60) not null,
      primary key(country_code)
      )type=innodb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  </code></pre>
  
  <p>MySQL says:</p>
  
  <blockquote>
    <p>#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 <code>type=innodb DEFAULT CHARACTER SET utf8    COLLATE utf8_general_ci</code> at line 5 </p>
  </blockquote>