              for a lock on table b, while Session 2 is blocked
                waiting for a lock on table a. The application can make
                no forward progress, and so it is deadlocked.
            </p>
        <p>
                When such a deadlock is detected one session loses the lock it got 
                when executing its last statement, and that statement is automatically rolled back.
                The rest of the statements in the session will still be valid, and you can 
         