This is a dumb question, but I have honestly spent a long time today trying to figure it out, and I'm sure I'm not the only one who has trouble with this.
How do you import a CSV directly into a MYSQL DB?
I've tried using
LOAD DATA LOCAL INFILE
in mysql, but it loads the entire spreadsheet into one row, or at least it seems like that's what it's doing? I've also tried doing this through phpMyAdmin by following these instructions: http://vegdave.wordpress.com/2007/05/19/import-a-csv-file-to-mysql-via-phpmyadmin/
Can anyone list out a few simple steps for me? I've got a huge CSV with like 500 rows and column headers at the top.