4 ms·
MySQL didn’t have transactions for years! A transaction layer can be implemented by adding a transaction table, a transaction column to each other table, and jo
by zeckalpha 4y ago
MySQL didn’t have transactions for years! A transaction layer can be implemented by adding a transaction table, a transaction column to each other table, and joining the two in your queries.
where table.transaction_id = transaction.id and transaction.committed = true
You would begin a transaction by inserting a new row and then updating it to committed when done.
With some metaprogramming you may be able to do this all transparently.