I was reading through the BNF grammar for transaction statements and saw that transaction modes can be specified directly in the START TRANSACTION statement. Is there a difference in specifying transaction modes in START TRANSACTION vs SET TRANSACTION statements?
Advertisement
Answer
No difference. The SET TRANSACTION setting only affects the single next
transaction to be started.
Use SET SESSION to set the default for the session’s transactions.