Re: Importing CSV into MySQL
| From: | David Robley | Date: | Thu, 12 Jan 2006 01:55:09 +0000 |
| Subject: | Re: Importing CSV into MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41021@lists.php.net to get a copy of this message | ||
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 explode() to get each column value for each row.
I think LOAD DATA INFILE might be one option
Cheers
--
David Robley
Are you really American if your ethnicity has to be hyphenated?