You need to make the column InnoDB not MYISAM // table type true InnoDB // Table type false not working MYISAM
MYISAM does not support transactions. You should use InnoDB