title: mysql syntax error 1064 (42000)
body: <p>I have a standard LAMP configuration (apache2, mysql, php5), running on ubuntu, and I'm just typing mysql commands into my terminal. I'm logged into the mysql command line as root. So far I've created a new database, but now trouble started.</p>
  
  <p>I'm trying to create a simple table but am getting a mysql syntax error and can't figure out what I'm doing wrong.</p>
  
  <p>This is the error:</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 ')' at line 10
  </code></pre>
  
  <p>And this is my query:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `customers` (
    `uid` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` varchar(50) NOT NULL,
    `email` varchar(50) NOT NULL,
    `phone` varchar(100) NOT NULL,
    `password` varchar(200) NOT NULL,
    `address` varchar(50) NOT NULL,
    `city` varchar(50) NOT NULL,
    `created` datetime NOT NULL DEFAULT TIMESTAMP
  );
  </code></pre>
  
  <p>No idea what's wrong honestly.</p>