title: Adding new enum column to an existing table
body: <p>I'm trying to add a <code>gender</code> column to my table with this query:  </p>
  
  <pre><code>ALTER TABLE QRCodeUser ADD gender CHAR(1) enum('M','F') NOT NULL;
  </code></pre>
  
  <p>I get this error:</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 'enum('M','F') NOT NULL' at line 1</p>
  </blockquote>
  
  <p>What's my mistake?</p>