Create a savepoint before risky delete

Create a savepoint before risky delete

Easy SQL TCL 15 views
Explanation Complexity

Problem Statement

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

Example

LoginLogs
Safe delete

Constraints

Assume PostgreSQL-style interval

Input / Output Format

Input Format
SQL script
Output Format
Statements
Constraints
Assume PostgreSQL-style interval

Examples

Input:
LoginLogs
Output:
Safe delete

Example Solution (Public)

SQL 
BEGIN; SAVEPOINT before_delete; DELETE FROM LoginLogs WHERE logged_at < (CURRENT_TIMESTAMP - INTERVAL '365 days'); ROLLBACK TO before_delete; COMMIT;

Official Solution Code

BEGIN; SAVEPOINT before_delete; DELETE FROM LoginLogs WHERE logged_at < (CURRENT_TIMESTAMP - INTERVAL '365 days'); ROLLBACK TO before_delete; COMMIT;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.