Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    MYSQL Assignments Final PDF

    Uploaded by

    Ghanshyam Sharma
    The document describes a transaction involving a MySQL mitem table with columns for item code, name, and price. It sets autocommit to 0, inserts a new row but doesn't commit, then rolls back to remove it. It starts a transaction, updates all prices by 200, sets a savepoint, updates prices by 400, rolls back to the savepoint to undo the last update, and selects data at each step. The transaction demonstrates how to group SQL statements together, rollback/commit changes, and use savepoints within a transaction.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    MYSQL Assignments Final PDF

    Uploaded by

    Ghanshyam Sharma
    1K views1 page
    The document describes a transaction involving a MySQL mitem table with columns for item code, name, and price. It sets autocommit to 0, inserts a new row but doesn't commit, then rolls back to remove it. It starts a transaction, updates all prices by 200, sets a savepoint, updates prices by 400, rolls back to the savepoint to undo the last update, and selects data at each step. The transaction demonstrates how to group SQL statements together, rollback/commit changes, and use savepoints within a transaction.

    Original Title

    MYSQL Assignments Final.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a transaction involving a MySQL mitem table with columns for item code, name, and price. It sets autocommit to 0, inserts a new row but doesn't commit, then rolls back to remove it. It starts a transaction, updates all prices by 200, sets a savepoint, updates prices by 400, rolls back to the savepoint to undo the last update, and selects data at each step. The transaction demonstrates how to group SQL statements together, rollback/commit changes, and use savepoints within a transaction.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1K views1 page

    MYSQL Assignments Final PDF

    Uploaded by

    Ghanshyam Sharma
    The document describes a transaction involving a MySQL mitem table with columns for item code, name, and price. It sets autocommit to 0, inserts a new row but doesn't commit, then rolls back to remove it. It starts a transaction, updates all prices by 200, sets a savepoint, updates prices by 400, rolls back to the savepoint to undo the last update, and selects data at each step. The transaction demonstrates how to group SQL statements together, rollback/commit changes, and use savepoints within a transaction.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    MYSQL DATABASE TRANSACTION ASSIGNMENT – 3

    question : given below the mitem table.

    icode iname iprice


    101 chair 1500
    102 dining table 24000

    what will be the output


    select * from mitem;
    set autocommit=0;
    insert into mitem values(103,’coffee table’,340);
    select * from mitem;
    rollback;
    select * from mitem;
    start transaction;
    update mitem set iprice=iprice+200;
    savepoint s1;
    update mitem set iprice=iprice+400;
    select * from mitem;
    rollback to s1;
    select * from mitem;

    FIRST FLOOR, OPPOSITE BANK OF BARODA,


    AJMER ROAD, KISHANGARH (RAJ) 305801 CALL : +91 98291-71122
    EMAIL : infotechcomputer@gmail.com | WEBSITE : www.infotechcomputer.in

    You might also like