List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2002 8:48pm
Subject:Re: Load Infile to more than one table
View as plain text  
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.

Thread
Load Infile to more than one tableAndrew Hazen10 May
  • Re: Load Infile to more than one tablePaul DuBois10 May