CODE EXAMPLE FOR SQL

autocommit mysql

SET AUTOCOMMIT=true;
-- or
SET AUTOCOMMIT=1;
-- get current autocommit status:
SELECT @@autocommit;