Autocommit off workflow
SQL
Medium
2 views
Problem Description
Write a simple script that turns autocommit off, runs two updates, then commits.
Sample Test Case
Output:
Committed updates
Constraints
DB-specific; show common idea
Official Solution
SET AUTOCOMMIT = 0; UPDATE Orders SET status='PACKED' WHERE order_id=7001; UPDATE Orders SET status='PACKED' WHERE order_id=7002; COMMIT; SET AUTOCOMMIT = 1;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!