Page 1 of 1

roll back

Posted: Fri Jul 24, 2009 12:41 am
by vijayan.nat
hi to all
Is possible roll back in mysql and i am interested to learn procudure and function in mysql give me some suggetions

Re: roll back

Posted: Fri Jul 24, 2009 1:08 am
by Darhazer
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