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]

Reply via email to