Re: Importing CSV into MySQL
| From: | Philip Hallstrom | Date: | Thu, 12 Jan 2006 02:11:46 +0000 |
| Subject: | Re: Importing CSV into MySQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41022@lists.php.net to get a copy of this message | ||
But then the file has to be on the db server first... if my memory is right.I remember reading in a book that there is a function to import the content of a CSV file into a MySQL table, am I alright? what is that function? Of course, the first option could be reading the CSV file line by line and using explode() to get each column value for each row.I think LOAD DATA INFILE might be one option