Changes between Version 2 and Version 3 of Transakcii


Ignore:
Timestamp:
02/12/26 00:35:44 (12 days ago)
Author:
213192
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Transakcii

    v2 v3  
    3131
    3232SELECT highest_market_value_in_eur
    33 
    3433FROM players
    35 
     34WHERE player_id = 26;
     35UPDATE players
     36SET highest_market_value_in_eur = 7000000
    3637WHERE player_id = 26;
    3738
    38 UPDATE players
    39 
    40 SET highest_market_value_in_eur = 7000000
    41 
     39COMMIT;
     40}}}
     41{{{
     42SELECT highest_market_value_in_eur
     43FROM players
    4244WHERE player_id = 26;
    43 
    44  
    45 
    46 COMMIT;
    47 
    48 SELECT highest_market_value_in_eur
    49 
    50 FROM players
    51 
    52 WHERE player_id = 26;
    53 
    54  
    55 
    56  
    5745
    5846COMMIT;
    … …  
    6452BEGIN ISOLATION LEVEL SERIALIZABLE;
    6553
    66  
    67 
    6854SELECT highest_market_value_in_eur
    69 
    7055FROM players
    71 
    7256WHERE player_id = 26;
    7357
    74  
    75 
    7658UPDATE players 
    77 
    7859SET highest_market_value_in_eur = 9000000 
    79 
    8060WHERE player_id = 26; 
    8161
    8262COMMIT; 
    8363
    84  
    85 
    86  
    87 
    8864SELECT highest_market_value_in_eur
    89 
    9065FROM players
    91 
    9266WHERE player_id = 26;
    93 
    94  
    95 
    96  
    9767
    9868COMMIT;
    … …  
    10777{{{
    10878BEGIN; 
    109 
    110  
    111 
    11279SELECT * FROM players WHERE player_id = 10 FOR UPDATE; 
    113 
    114  
    115 
    11680SELECT * FROM players WHERE player_id = 20 FOR UPDATE; 
    117 
    118  
    119 
    12081COMMIT;
    12182
    12283BEGIN;
    123 
    124  
    125 
    12684SELECT * FROM players WHERE player_id = 20 FOR UPDATE;
    127 
    128  
    129 
    13085SELECT * FROM players WHERE player_id = 10 FOR UPDATE;
    131 
    132  
    133 
    13486COMMIT;
    13587}}}