Load Data into more than 1 Table

"Scott Simpson" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Can I use 'LOAD DATA INFILE' to load data into more than 1 table?
 
For example, say I have a text file containing
 
1       birthday       cat
2       anniversary    dog
 
and I want column 2 in table birthdays and column 3 in table pets and
I'm lazy and can't be bothered to split the file or loop through an
insert statement.  
 
Can someone suggest a shortcut?
 
Thanks,
Scott
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.