... 1 row affected by each query
if ($a1==1 && $a2==1) {
//Everything looks OK, commit changes
$mysqli->commit();
} else
//Something went wrong. Roll back to before begin_transaction()
$mysqli->rollback();
}
$mysqli->close();
mysqli->begin_transaction() ...
... @UpdateCursor INTO @Data
END
CLOSE @UpdateCursor
DEALLOCATE @UpdateCursor
COMMIT TRANSACTION A
--print 'committed'
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION A
...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.