Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Inserting into several linked MySQL tables.

by mpeters (Chaplain)
on Sep 27, 2005 at 16:47 UTC ( [id://495453] : note . print w/replies, xml ) Need Help??


in reply to Inserting into several linked MySQL tables.

Which version of MySQL are you using? Transactions have been around for a while. What I think you need more than anything though is a foreign key constraint. Check out the InnoDB storage engine for MySQL.

-- More people are killed every year by pigs than by sharks, which shows you how good we are at evaluating risk. -- Bruce Schneier