MySQL Transaction Gotchas & Good Parts

In my previous post, “MySQL Transactions & Why You Can’t Emulate Them in PHP” we discussed why transactions are useful and how a few simple SQL commands can make your application more robust. But few things are that easy in the life of a web developer… Statements you can’t ROLLBACKUnfortunately, ROLLBACK isn’t a global undo for every database action. If you make a fundamental change to the schema