title: Is it possible that a primary key is not autoincrement?
body: <p>I am trying to insert an element in a table where there are already 3 rows.</p>
  
  <p>Its a table called <strong><em>usuarios</em></strong>=[<strong>id</strong> (primary, autoincrement), <strong>fid</strong>, <strong>first_name</strong>, <strong>last_name..</strong>..]</p>
  
  <p>So there are already 3 rows with id's: <strong>0,1,2</strong></p>
  
  <p>And when I am trying to execute this query (note I am not setting value for id attribute)</p>
  
  <pre><code>INSERT INTO usuarios (fid,email,pass,first_name,last_name,avatar,bday,fecha,id_loc,id_loc_from) 
         VALUES       (-1,'toni@ideadeia.com','72253f579e7dc003da754dad4bd403a6','','','',NOW(),NOW(),'','')
  </code></pre>
  
  <p>I get this mysql error:</p>
  
  <pre><code>Duplicate entry '0' for key 1
  </code></pre>
  
  <p>extra: I don't know how this 3 items where inserted (if via interface, by console query, ..)</p>
  
  <p>So question is, how can I make sure that the <code>Primary Key</code>is autoincrement, and if not; how to set it? (will that solve the problem?)</p>