MySQL Commit and Rollback
Mike Anderson
We're trying to use manual commit with MySQL in
Miva Empressa, and we need to know whether or not an MvClose will close the
session with MySQL and cause MySQL to roll back changes if we've not used a
COMMIT. Also, if the script crashes, times out, or otherwise ends unexpectedly,
will MySQL rollback the changes? We need to be certian we understand when MySQL
will issue a rollback and when it won't, so we know what data integrity issues
we need to watch for when using manual commit. Is anyone well-versed in this?
TIA!
Mike Anderson
mvmarkus
Hi Mike,
My understanding is that if your script gets interrupted before you committed the record, the record (s) shouldn’t be saved at all. After all, that is the idea of a transaction.
Markus
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"miva-script" group.
To post to this group, send email to miva-...@googlegroups.com
To unsubscribe from this group, send email to
miva-script...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/miva-script
-~----------~----~----~----~------~----~------~--~---