Create a savepoint before risky delete

SQL Easy 1 views
Back to Questions
Previous Rollback on mistake Easy P Next Use transaction block for multiple steps Easy N

Problem Description

Before deleting old logs, create a savepoint. If you feel too many rows got deleted, rollback to the savepoint; otherwise commit.

Input Format

SQL script

Output Format

Statements

Sample Test Case

Input:
LoginLogs
Output:
Safe delete

Constraints

Assume PostgreSQL-style interval
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next