How about....
LOAD DATA INFILE 'filename.txt'
INTO TABLE Table
FIELDS TERMINATED BY ',' <---- comma delimited for tabs use '\t'
LINES TERMINATED BY '\n' <---- *nix line terminator, for Dos/Win use
'\r\n'
IGNORE 1 LINES <---- use if the first line of the file has col.
hdrs.
(column1name, column2name, column3name, column4name);
--
__ _ Tyler Nally
/ /__ ____ _(_)___ ____ ____ _________ _ [EMAIL PROTECTED]
/ / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016
/ / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website
/_/\___/\__, /_/\____/_/ /_(_)____/_/ \__, / http://www.legion.org
/____/ /____/
> -----Original Message-----
> From: Kelvin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 04, 2002 11:44 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] How to insert to DB from txt??? Please help
>
>
> Hi everyone,
>
> I have a txt file which is contained the following:
>
> xxxx,aaa,ccc,ddd
> xxxx,aaa,ccc,ddd
> .....etc.
>
> Now, I need to read the data from that file and than
> insert it into the
> table.
>
> ----insert into Table ("name","pass","phone","somethingelse")
>
> Could someone help me out here, How to write the code?
> I know how to read from a txt file, but I don't know how
> to separate the
> data determine by ","
>
> Please help, I'll be very appreciate.Thanks
>
> Kelvin.
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
