title: insert values into table with auto increment primary key? I keep getting errors
body: <p>Alright, so I'm getting the error:</p>
  
  <pre><code>#1062 - Duplicate entry '0' for key 'PRIMARY'
  </code></pre>
  
  <p>on this table:</p>
  
  <pre><code>CREATE TABLE links (
          ID smallint(6) NOT NULL default '0',
          Position smallint(6) NOT NULL default '0',
          Name text NOT NULL,
          url text NOT NULL,
          IP text NOT NULL,
          PRIMARY KEY (ID)
          ) TYPE=MyISAM; 
  </code></pre>
  
  <p>using this command:</p>
  
  <pre><code>INSERT INTO links(Position, Name, url, IP) VALUES(0, "Google", "http://www.google.com", "0.0.0.0")
  </code></pre>
  
  <p>The table is only has one row in it, so why the heck isn't the auto increment working? :&lt;</p>