Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- START TRANSACTION
- Frank Natoli
April 28, 2005, 12:05 am
rate this thread
After START TRANSACTION but before COMMIT, are intervening SQL transactions
visible to other threads or processes? I understand that failing to perform
a COMMIT, or explicitly performing a ROLLBACK, results in the transactions
occurring after START TRANSACTION being undone. But until and if the
transactions are undone, would queries to the database reveal those
Re: START TRANSACTION
Frank Natoli wrote:
If this were so, it would constitute what is called a "dirty read".
That is, being able to view partially finished, uncommitted updates from
According to the documentation, InnoDB does not provide this style of
transaction isolation (if it can be called that).
for more information.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum