title: What's wrong with this very simple mysql create table statement?
body: <pre><code>create table foo(
  id UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  barbaz VARCHAR(50) CHARACTER SET utf8
  )
  </code></pre>
  
  <p>[<strong>Edit</strong>]: OK I had accidentally removed the INT and I didn't realize it (these statements are generated automatically).[<strong>/Edit</strong>]</p>
  
  <p>This gives me this error:</p>
  
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  barbaz VARCHAR(50) CHARACTER SET '</p>
  
  <p>Yeah, I'm using Maria DB as it replaces mysql in Fedora, but supposedly it's exactly the same syntax as Mysql.</p>
  
  <p>Thanks for your help.</p>