Re: [PHP-DB] Importing CSV into MySQL

2006-01-11 Thread David Robley
On Thu, 12 Jan 2006 11:18, Miguel Guirao wrote: Hi all, 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

Re: [PHP-DB] Importing CSV into MySQL

2006-01-11 Thread Philip Hallstrom
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

RE: [PHP-DB] Importing CSV into MySQL

2006-01-11 Thread Bastien Koert
with php, you could upload the file, then use fget_csv to pull the data in and insert it into the table bastien From: Miguel Guirao [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Importing CSV into MySQL Date: Wed, 11 Jan 2006 18:48:32 -0600 Hi all, I remember reading in a