MySQL Transaction

CREATE TABLE EMPLOYEE
(
  EMPLOYEE_ID   CHAR(5)  NOT NULL,
  EMPLOYEE_NAME VARCHAR(50) NOT NULL,
PRIMARY KEY (EMPLOYEE_ID))
ENGINE = INNODB;

Autocommit mode
SET AUTOCOMMIT=0;
SET AUTOCOMMIT=1;

Implicit mode:
COMMIT
ROLLBACK
SAVEPOINT
START TRANSACTION
Read full article from MySQL Transaction