可以在MySQL触发器中执行ROLLBACK吗? [英] Is possible to do a ROLLBACK in a MySQL trigger?

问题描述

这就是问题:可以在MySQL触发器中进行ROLLBACK吗?

Just that is the question: is possible to do a ROLLBACK in a MySQL trigger?

如果答案是肯定的，那么请解释如何做.

If answer is yes, then, please, explain how.

推荐答案

如果触发器引发异常，则会中止事务，从而有效回滚.这对您有用吗?

If the trigger raises an exception, that will abort the transaction, effectively rolling back. Will this work for you?

这篇关于可以在MySQL触发器中执行ROLLBACK吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！