[dsp1234]

"Some statements cannot be rolled back. In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines." [0]

[0] - https://dev.mysql.com/doc/refman/5.7/en/cannot-roll-back.htm...