title: trying to import CSV into phpMyAdmin
body: <p>I am trying to import a <code>.csv file</code> into <code>phpMyAdmin</code>.</p>
  
  <p><strong>My table is formatted as follows:</strong></p>
  
  <pre><code>id,
  staffnum,
  city,
  height,
  eye,
  hair,
  titles
  </code></pre>
  
  <p><strong>The file is formatted as follows:</strong></p>
  
  <pre><code>"63,losangeles,5'10,green,Brown,Bartender"
  "86,losangeles,5'9,blue,blonde,Bartender, Cocktail"
  "263,newyork,6'1,blue,blonde,Cocktail"
  "325,losangeles,5'10,brown,Brown,Bartender"
  "545,newyork,6',brown,Brown,Bartender, Cocktail"
  </code></pre>
  
  <p>The issue I believe I am running into is that the positions (Bartender, Cocktail etc) are to go in to the column titles and I don't have the correct formatting. Do I need to use single quotes around values with multiple commas such as:</p>
  
  <pre><code>"86,losangeles,5'9,blue,blonde,'Bartender, Cocktail'"
  </code></pre>
  
  <p>Also, will the apostrophes in the height section cause issues when uploading a <code>CSV</code> file? I've search online but no one seems to have the clear set instructions on how the <code>CSV</code> file is supposed to be formatted. I have tried importing this and it says success however, no values are applied to any of the fields.</p>
  
  <p>File is <a href="http://www.2shared.com/file/5y_kESkh/staff.html" rel="nofollow">here</a></p>