“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.”