title: How do I import a csv file with phpmyadmin containing 1 column into my mysql database?
body: <p>I added a new column on my existing database table.</p>
  <p>I have saved all the data I want to add an Excel table, under a new column called &quot;path&quot; and have saved it as .csv</p>
  <p>My existing table has 12 columns and 5000 rows.</p>
  <p>I have tried many different attempts as using the Import option but none work.  I get no error messages, but no data is added.</p>
  <p>Attempt #1:
  I saved only 2 columns of data:
  id,path</p>
  <p>(The &quot;id&quot; is a unique auto-incrementing number identifier)</p>
  <p>Attempt #2:
  I saved only 1 column of data:
  path</p>
  <p>Attempts #3 and #4 were using the above attempts, but removing the row with column names from the .csv
  This still did not work.</p>
  <p>phpMyAdmin used to have an Import option checkbox for &quot;The first line of the file contains the table column names (if this is unchecked the first line will become part of the data).  However, this no longer appears as an option.</p>
  <p>Nothing I am doing is working... please tell me how to make this work.</p>