Quote:
Originally Posted by fowlplay4
My understanding of it is:
BEGIN;
.. a bunch of statements, that should all fail if one doesn't go through ..
COMMIT;
|
That's also my understanding of it. Note also that you can get greatly improved write speeds with INSERT/UPDATE if executing many queries if you do them in a transaction.