title: ERROR 1064 (42000): You have an error in your SQL syntax
body: <p>Trying to create a table in MySQL using:</p>
  
  <pre><code> CREATE TABLE users (  
      id INT(5) NOT NULL ZEROFILL AUTO_INCREMENT PRIMARY KEY ,  
      passport VARCHAR(250) NOT NULL ,
      nickname VARCHAR(250) NOT NULL ,
      mail VARCHAR(250) NOT NULL ,  
      password VARCHAR(250) NOT NULL ,  
      age INT(2) NOT NULL ,
      sex VARCHAR(250) NOT NULL ,  
      is_registered VARCHAR(1) NOT NULL DEFAULT 1 ,
      is_registered_timestamp TIMESTAMP NOT NULL ZEROFILL , 
      is_admin VARCHAR(1) NOT NULL DEFAULT 0 ,
      is_admin_timestamp TIMESTAMP NOT NULL ZEROFILL ,
      is_banned VARCHAR(1) NOT NULL DEFAULT 0 ,
      is_banned_timestamp TIMESTAMP NOT NULL ZEROFILL
      ); 
  </code></pre>
  
  <p>Getting the error message:</p>
  
  <pre><code>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 'ZEROFILL AUTO_INCREMENT PRIMARY KEY ,
  `passport` VARCHAR(250) NOT NULL ,
  `nick' at line 2
  </code></pre>
  
  <p>What does this mean? I am new to MySQL and have read as much as possible to try and understand the different data types, and assume I've used the correct data types so can't understand what this error message is trying to say.</p>