Want to use a trigger in mysql, you need to use transaction, the trigger can write, but how to add the transaction to the trigger in the HeidiSQL

CodePudding user response:

The trigger in the operation, and trigger its statement in a transaction, so you don't need to add the transaction to the trigger on
Trigger the trigger of the statement is rolled back, the trigger in the operation of the natural also rolled back