hi to all
Is possible roll back in mysql and i am interested to learn procudure and function in mysql give me some suggetions
roll back
Moderator: General Moderators
Re: roll back
START TRANSACTION
COMMIT
ROLLBACK
InnoDB supports those, MyISAM do not support transactions and it have an auto-commit.
Interesting thing is that if you perform COMMIT in a MyISAM table, the last query will be executed for a second time.
Also, you have to know that starting a transaction commits the previous one... and that queries that affect table / database structure, also commit the transaction.
You can find more information, of course, in the manual
COMMIT
ROLLBACK
InnoDB supports those, MyISAM do not support transactions and it have an auto-commit.
Interesting thing is that if you perform COMMIT in a MyISAM table, the last query will be executed for a second time.
Also, you have to know that starting a transaction commits the previous one... and that queries that affect table / database structure, also commit the transaction.
You can find more information, of course, in the manual