Re: Load Infile to more than one table

[Paul DuBois]

At 15:08 -0400 5/10/02, Andrew Hazen wrote:
>Hi Folks,
>
>Can I do the following:
>
>LOAD DATA INFILE 'persondata.txt'
>       INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);

No.

You could extract the columns you need from the file for each table
into two separate files, then run two LOAD DATA statements.

>
>Mysql the spam filter.
>
>Andrew Hazen, O.C.P.
>E-Commerce Developer
>Jatech Solutions Inc.
>www.jatech.ca
>Specializing in OSCOMMERCE applications and PHP/MySQL programming.