Re: Load Data into more than 1 Table
Dan Bolser <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Perhaps man column (on linux) can help you.. Else I would load both and make a join to get what you want (if that is possible). Finally I would use a perl one liner to hack the files up. On Wed, 3 Nov 2004, 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]