Autocommit
You can control the behavior of transaction by setting the session variable called AUTOCOMMIT. if AUTOCOMMIT is set to 1(the default),then each SQL statment(within a transaction or not) is considered to be a complete transaction and committed by default finishes. When AUTOCOMMIT is set to 0,by issuing the SET AUTOCOMMIT=0 command, the subsequent series of… Read More »