Importing CSV files with phpMyAdmin
phpMyAdmin, a handy MySQL administration tool, has a feature allowing you to import data into your database as a CSV file. I had some difficulties with it, so this short post just outlines what I found out.
The main trick has to do with column names. If you select either the “CSV” or “CSV Load Data” [...]
