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