Re: Load Data into more than 1 Table

Once the writeable views support is functional, you should be able to 
just create a view that joins the two tables and has the interface 
matching your file; then just insert into the view from each file 
line. -- Darren Duncan

At 4:49 PM +0000 11/3/04, Scott Simpson wrote:
>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

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]