Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Rolling Back A Transaction in MySql

    @anupam.verma
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 1.10k
    Comment on it

    Transactions are very important part of MySql and for handling the transactions the Transaction Control Language (TCL) is used. Transactions are basically used to handle all the changes made in the database. Rolling back a transaction means storing the database to the last commited state. The Rollback statement can be understood with the help of other statements. The following commands should be understood for rollback of the transaction:-

    • COMMIT- This command is used to permanently save the transaction made in the database.
    • SAVEPOINT- This command is used to mark a point where whenever you want you can rollback to that point.
    • ROLLBACK-This command is used for rolling back or restoring the transaction to any savepoint in the database.

    Example for rollback of transaction-
    Suppose there is a table by name Customers

    1. PId                  NAME                     COUNTRY
    2.  1                   John                    Australia
    3.  2                  Robert                    England
    4.  3                 Chi-zung                    China

    INSERT into CUSTOMERS values(4,'alex','Germany');
    commit;
    UPDATE CUSTOMERS set name='Julia' where PId='4';
    savepoint A;

    Now the table will look like:-

    1.    PId                  NAME                     COUNTRY
    2.      1                  John                    Australia
    3.      2                 Robert                    England
    4.      3                 Chi-zung                  China
    5.      4                 Julia                     Germany

    Now if we have to rollback the transaction to the SAVEPOINT A , the command should be-

    rollback to A;
    SELECT * from CUSTOMERS;

    1.  PId                  NAME                     COUNTRY
    2.    1                  John                    Australia
    3.    2                 Robert                    England
    4.    3                 Chi-zung                  China
    5.    4                 Julia                     Germany
    Transaction Control Language mysql rollback database
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: