I have an application which uses remote MySql database (it connects the database via internet).
The Internet of one of my clients is very unstable.
Because of this I intend to put the Sql statements in a transaction.
The question is: if I start a transaction and in the middle of it there is a "Lost connection" with the database, the previous Sql statements will roll back, right?
Thank you very much.