Linux Today: Linux News On Internet Time.

PHPeveryWhere: Simulating Transactions in MySQL

Sep 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."

Complete Story

Related Stories: