Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    A6 U2 Niveles de Aislamiento

    Uploaded by

    Vergara vlogs
    This document discusses database transaction isolation levels. It shows examples of inserting, updating, and selecting data from a sample "alumnos" table using different isolation levels between two MySQL sessions, including read committed, read uncommitted, repeatable read, and serializable. The examples demonstrate how the transactions are handled and view of data differs under each isolation level.

    Copyright:

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

    A6 U2 Niveles de Aislamiento

    Uploaded by

    Vergara vlogs
    11 views8 pages
    This document discusses database transaction isolation levels. It shows examples of inserting, updating, and selecting data from a sample "alumnos" table using different isolation levels between two MySQL sessions, including read committed, read uncommitted, repeatable read, and serializable. The examples demonstrate how the transactions are handled and view of data differs under each isolation level.

    Original Description:

    Niveles de aislamiento mysql

    Original Title

    A6 U2 Niveles de aislamiento

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses database transaction isolation levels. It shows examples of inserting, updating, and selecting data from a sample "alumnos" table using different isolation levels between two MySQL sessions, including read committed, read uncommitted, repeatable read, and serializable. The examples demonstrate how the transactions are handled and view of data differs under each isolation level.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    11 views8 pages

    A6 U2 Niveles de Aislamiento

    Uploaded by

    Vergara vlogs
    This document discusses database transaction isolation levels. It shows examples of inserting, updating, and selecting data from a sample "alumnos" table using different isolation levels between two MySQL sessions, including read committed, read uncommitted, repeatable read, and serializable. The examples demonstrate how the transactions are handled and view of data differs under each isolation level.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 8

    Universidad Tecnológica de Ciudad Juárez.

    A6 U2 Niveles de aislamiento

    Guillermo Vergara Aguirre

    23110456

    3er Cuatrimestre

    TDM32

    Docente: Sueisen Barraza

    Bases de Datos para Aplicaciones.

    Ciudad Juárez Chihuahua México

    12/11/2023
    T1 (Workbench)
    T2 Mysql Linea de comandos

    > INSERT INTO alumnos VALUES (6, > SELECT * FROM alumnos WHERE
    'alumno6'); id=6; Empty set (0.00 sec)
    > SELECT * FROM alumnos WHERE
    id=6;
    +----+---------+
    | id | alumno |
    +----+---------+
    | 6 | alumno6 |
    +----+---------+

    > COMMIT; COMMIT;


    Query OK, 0 rows affected (0.00 sec)

    > SELECT * FROM alumnos WHERE


    id=6;

    +----+---------+
    | id | alumno |
    +----+---------+
    | 6 | alumno6 |
    +----+---------+
    1 row in set (0.00 sec)

    UPDATE alumnos SET alumno = SELECT * FROM ALUMNOS WHERE


    'Alberto Carrera' WHERE id=1; id=1;
    +----+----------+
    Query OK, 1 row affected (0.01 sec) | id | alumno |
    Rows matched: 1 Changed: 1 +----+----------+
    Warnings: 0 | 1 | alumno 1 |
    +----+----------+
    > SELECT * FROM ALUMNOS 1 row in set (0.00 sec)
    WHERE id=1; > UPDATE alumnos SET alumno =
    +----+-----------------+ 'Raquel Carrera' WHERE id = 2;
    | id | alumno | Query OK, 1 row affected (0.02 sec)
    +----+-----------------+ Rows matched: 1 Changed: 1
    | 1 | Alberto Carrera | Warnings: 0
    +----+-----------------+ l> SELECT * FROM ALUMNOS
    1 row in set (0.00 sec) WHERE id=2;
    +----+----------------+
    | id | alumno |
    +----+----------------+
    | 2 | Raquel Carrera |
    +----+----------------+
    1 row in set (0.00 sec)

    mysql> SELECT * FROM ALUMNOS mysql> SELECT * FROM ALUMNOS;


    WHERE id=2; +----+----------------+
    +----+----------+ | id | alumno |
    | id | alumno | +----+----------------+
    +----+----------+ | 1 | alumno 1 |
    | 2 | alumno 2 | | 2 | Raquel Carrera |
    +----+----------+ | 3 | alumno 3 |
    1 row in set (0.00 sec) | 4 | alumno 4 |
    mysql> COMMIT; | 5 | alumno 5 |
    Query OK, 0 rows affected (0.01 sec) | 6 | alumno6 |
    mysql> SELECT * FROM ALUMNOS; +----+----------------+
    +----+-----------------+ 6 rows in set (0.00 sec)
    | id | alumno | mysql> COMMIT;
    +----+-----------------+ Query OK, 0 rows affected (0.02 sec)
    | 1 | Alberto Carrera | mysql> SELECT * FROM ALUMNOS;
    | 2 | alumno 2 | +----+-----------------+
    | 3 | alumno 3 | | id | alumno |
    | 4 | alumno 4 | +----+-----------------+
    | 5 | alumno 5 | | 1 | Alberto Carrera |
    | 6 | alumno6 | | 2 | Raquel Carrera |
    +----+-----------------+ | 3 | alumno 3 |
    6 rows in set (0.00 sec) | 4 | alumno 4 |
    | 5 | alumno 5 |
    | 6 | alumno6 |
    +----+-----------------+
    6 rows in set (0.00 sec)
    mysql> SELECT * FROM ALUMNOS;
    +----+-----------------+
    | id | alumno |
    +----+-----------------+
    | 1 | Alberto Carrera |
    | 2 | alumno 2 |
    | 3 | alumno 3 |
    | 4 | alumno 4 |
    | 5 | alumno 5 |
    | 6 | alumno6 |
    +----+-----------------+
    6 rows in set (0.00 sec)
    mysql> COMMIT;
    Query OK, 0 rows affected (0.00 sec)
    mysql> SELECT * FROM ALUMNOS;
    +----+-----------------+
    | id | alumno |
    +----+-----------------+
    | 1 | Alberto Carrera |
    | 2 | Raquel Carrera |
    | 3 | alumno 3 |
    | 4 | alumno 4 |
    | 5 | alumno 5 |
    | 6 | alumno6 |
    +----+-----------------+
    6 rows in set (0.00 sec)
    T1 (Workbench)
    T2 Mysql Linea de comandos

    READ COMMITED
    T1 (Workbench)
    T2 Mysql Linea de comandos

    READ UNCOMMITED

    Commit;
    T1 (Workbench)
    T2 Mysql Linea de comandos

    REPEATABLE READ

    Commit;
    T1 (Workbench)
    T2 Mysql Linea de comandos

    SERIALIZABLE

    Commit;

    You might also like