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 read

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 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

[PHP-DB] Importing CSV into MySQL

2006-01-11 Thread Miguel Guirao
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 explode() to get each column value for each row. Best Re