Camilo Sperberg - 2012-10-10 15:15:41 - In reply to message 1 from Onur
Hello, sorry for the late reply but I didn't notice this message before.
As far as I have tested, there are some restrictions of MySQL regarding transactions.
- It will only work with InnoDB type tables
- DDL statements (ALTER TABLE; CREATE TABLE; etc) are not a part of transaction, it means that they will do an implicit COMMIT (More info on the link below).
- A maximum of 1023 can be done in one transaction
If you want a more complete and robust solution regarding transactions, I seriously recommend you use another RDBMS, such as PostGreSQL for which I have another class where transactions will always work, even DDL statements will execute within a transaction.