|transaction commands(commit,ROLLBACK ) do not cause|
|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
That are the ones I've been able to detect so far. However, you should read more about this topic on this link:
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.