Page 1 of 1

Convert csv to mysql

Posted: Fri Sep 22, 2006 5:46 pm
by Luke
What do y'all use to convert csv (comma delimited) files to mysql tables? Isn't phpmyadmin supposed to be able to do this? Mine doesn't give me that option...

Posted: Fri Sep 22, 2006 5:56 pm
by feyd
There's fgetcsv(), there's mysqlimport, LOAD DATA INFILE.. a few other options around here and there...

viewtopic.php?t=22168 for a previous thread...

Posted: Fri Sep 22, 2006 6:14 pm
by Luke
LOAD DATA INFILE worked like a charm... didn't know about that one... thanks man!