Re: Upload csv file into mysql
| From: | Ignatius Reilly | Date: | Wed, 04 Sep 2002 07:50:45 +0000 |
| Subject: | Re: Upload csv file into mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21557@lists.php.net to get a copy of this message | ||
Hi Dr,
try:
LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
FIELDS TERMINATED BY ","
LINES TERMINATED BY "\r\n" ;
of course, the structure of your CSV file must match exactly that of your
table.
hth
----- Original Message -----
From: "Dr. Indera" <dr.indera@verizon.net>
To: <php-db@lists.php.net>
Sent: Wednesday, September 04, 2002 6:20 AM
Subject: [PHP-DB] Upload csv file into mysql
> Hello,
>
> Is there a way to upload data in a csv file into a mysql table?
>
> Thanks
> Indera
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>