Re: Load Infile to more than one table

2002-05-10 Thread 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 tw

Load Infile to more than one table

2002-05-10 Thread Andrew Hazen
Hi Folks, Can I do the following: LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...); 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 prog