<div>
<div class="content wysiwyg-content">
Let's say i want to do 3 updates. The second update is not valid(the key doesn't exist in the db). <br />
So i want to roll back all 3 updates. <br />
connection.setAutoCommit(f<wbr />alse);<br />
3 updates<br />
connection.commit()<br />
<br />
<br />
Will that work
</div>
</div>


Let's say i want to do 3 updates. The second update is not valid(the key doesn't exist in the db). 
So i want to roll back all 3 updates. 
connection.setAutoCommit(false);
3 updates
connection.commit()


Will that work

SQL: Want to update multiple rows, but roll back if any of the updates fails.

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.