PHPeveryWhere: Simulating Transactions in MySQLSep 25, 2000, 21:02 (4 Talkback[s])
(Other stories by John Lim)
"Transactions is a technology that ensure that if you have to update multiple tables and you crash midway, you can rollback the data to a consistent state just before the crash...."
"MySQL is the most popular open source database on Earth. The current stable release, 3.22 does not support transactions, but with a little bit of intelligence and discipline, we can simulate transactions."
"An example of how we use transactions is a shopping cart system after checkout. Here we are generating an invoice and the invoice items based on the contents of a shopping_cart_items table."