roll back

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
vijayan.nat
Forum Newbie
Posts: 1
Joined: Fri Jul 24, 2009 12:04 am

roll back

Post 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
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: roll back

Post 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
Post Reply