title: Create mysql table in phpmyadmin sql window
body: <p>I'm trying to create a <code>mysql</code> table in <code>XAMPP</code> sql command window within an existing <code>database</code> with following code</p>
  
  <pre><code>CREATE TABLE hello_world (
      id text NOT NULL,
      password text,
      contact text,
      email text,
      friends text,
      time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
      UNIQUE KEY id
  );
  </code></pre>
  
  <p>but get the following error in <code>phpmyadmin</code></p>
  
  <blockquote>
    <p>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 9</p>
  </blockquote>