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