SQL Transactions Flashcards
1
Q
BEGIN
A
Begins a transaction in the current session.
2
Q
COMMIT
A
Commits an open transaction in the current session.
3
Q
ROLLBACK
A
Rolls back an open transaction in the current session.
4
Q
SHOW LOCKS
A
Lists all running transactions that have locks on resources.
5
Q
SHOW TRANSACTIONS
A
List all running transactions.