title: MySQL error - #1062 - Duplicate entry ' ' for key 2
body: <p>I'm trying to insert a huge list of users to a MySQL database but everytime I try I get the error: </p>
  
  <pre><code>#1062 - Duplicate entry '' for key 2
  </code></pre>
  
  <p>It gives me this because the 2nd column is blank on quite a lot of the entries, so after it's inserted one blank entry in column 2, it won't let me add another. However, when I added most of the list yesterday I didn't get this error once even though a lot of the entries I added yesterday have a blank cell in column 2 as well. Whats going on? </p>
  
  <p>This is the sql code to insert 1 entry. The rest follow the same format:</p>
  
  <pre><code>INSERT INTO users
    (`id`,`title`,`firstname`,`lastname`,`company`,`address`,`city`,`county`
     ,`postcode`,`phone`,`mobile`,`category`,`email`,`password`,`userlevel`) 
  VALUES     
    ('','','John','Doe','company','Streeet','city','county'
    ,'postcode','phone','','category','emial@email.co.uk','','');
  </code></pre>