in reply to DBI & Multiple Table Inserts, Foreign Key Inserts and Transactions

Depending on the version of MySQL, you can do updates against multiple tables. However, if you're having to update multiple tables and change the FK's, then you're doing something really weird. The FKs are just there to maintain integrity. If you're altering FKs, then you're losing integrity. If you're needing last_insert_id for FK'ed tables, that means you're creating the child before the parent, which also makes no sense. Or, am I missing something?
My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
  • Comment on Re: DBI & Multiple Table Inserts, Foreign Key Inserts and Transactions

In Section Seekers of Perl Wisdom