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