That's pretty much all there is to my question: Can schema changes be done within transactions in MySQL?
My understanding is no but I'm not having an easy time finding documentation that provides a definitive answer.
Implicit commit and cannot rollback sections of the mysql documentation quite clearly indicate, that schema changes should not be part of a transaction involving other commands, since they will either cause a commit, or the schema changes cannot be rolled back.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With