Re: How to insert from text file?
| From: | Jeff Gannaway | Date: | Sun, 16 Jul 2000 05:08:08 +0000 |
| Subject: | Re: How to insert from text file? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-6809@lists.php.net to get a copy of this message | ||
At 04:02 AM 7/16/00 -0400, Murph wrote:
>Hi.
>
>I'm sure this has been done time and again but I can't find it anywhere. Is
>there a snippet of code somewhere that will take a comma-delimited text file
>and append it to a database?
>
>Thanks. The help is appreciated by this newbie.
If you're using MySQL for the database use the:
LOAD DATA INFILE 'filename.txt'....
command. Just go to the MySQL web site and search the documentation for
LOAD DATA INFILE and you'll be on your way.
Later,
Jeff