how to turn autocommit off in mysql code example

Example: autocommit mysql

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