I use SQLyog as a client against MYSQL.
I would like to execute an SQL script an optionally commit or rollback (as with the client SQLDeveloper). How can I do that with SQLyog? I've searched the web and the help, to no avail.
If you start a DB Session with
You could also
Please make sure all involved tables are InnoDB
If any tables involved in UPDATE joins and DELETE joins involve a mixture of InnoDB and MyISAM, changes to the MyISAM table will not rollback since it does not support ACID-compliant transactions.
According to this article every client connect to mysql with enabled autocommit.
You can disabled it and work with rollback like in SQLdeveloper. But in contrast to the SQLdeveloper you need to execute commit statements manually.