MySql ENGINE=InnoDB

I used to face an issue although the transaction is rolled back in the code, the record is still inserted into the table.

Eventually, I found the table in MySQL was not set to ENGINE=InnoDB. To support transaction, the MySQL table should be set to ENGINE=InnoDB.