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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php