<div>
<a href="http://dev.mysql.com/doc/refman/5.0/en/commit.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/commit.html</a><br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/savepoints.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.0/en/savepoints.html</a>
</div>


<div>
This may be useful, I suggest you take a look at it.<br />
<br />
<a href="http://www.devshed.com/c/a/MySQL/Implementing-the-commit-and-rollback-Methods-with-mysqli-and-PHP-5/" rel="ugc">http://www.devshed.com/c/a/MySQL/Implementing-the-commit-and-rollback-Methods-with-mysqli-and-PHP-5/</a>
</div>


<div>
<div class="content wysiwyg-content">
It sounds crazy, but I can't find any examples of how to know when to rollback in a transaction.<br />
It is obvious that you do ROLLBACK to do it, but when?<br />
<br />
I have some INSERTS, UPDATES, etc. that need to take place in a transaction. &nbsp;This is MySQL 5.0 inside of a Stored Procedure or Stored Function. &nbsp;What do I do to test for failure on these and rollback? &nbsp;Please provide examples.<br />
<br />
Thanks
</div>
</div>


It sounds crazy, but I can't find any examples of how to know when to rollback in a transaction.
It is obvious that you do ROLLBACK to do it, but when?

I have some INSERTS, UPDATES, etc. that need to take place in a transaction.  This is MySQL 5.0 inside of a Stored Procedure or Stored Function.  What do I do to test for failure on these and rollback?  Please provide examples.

Thanks

Examples and Explanation of Transaction and Rollback for MySQL 5.0

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.