[PHP] PHP and Transactions with InnoDB

I could use some practical tips on doing transactions with InnoDB tables in MySQL. I want to grab and lock a record and do a whole load of related stuff, then make sure everything is updated in a consistent way, something like this skeleton: BEGIN SELECT * from blah WHERE something=n FOR

Re: [PHP] PHP and Transactions with InnoDB

I've not worked with InnoDb, but given that the web is a stateless space and all kinds of things can happen, I'd be very reluctant to lock a record until the very moment I'm updating it. In other words, when I have my batch of updates and inserts ready to go, then I'd begin by transaction,

Re: [PHP] PHP and Transactions with InnoDB

In article [EMAIL PROTECTED], Miles Thompson [EMAIL PROTECTED] wrote: I've not worked with InnoDb, but given that the web is a stateless space and all kinds of things can happen, I'd be very reluctant to lock a record until the very moment I'm updating it. In other words, when I have my