Procedure to clean old logs

Procedure to clean old logs

Easy SQL Stored Procedures 18 views
Explanation Complexity

Problem Statement

Create sp_delete_old_logs(p_days) that deletes from LoginLogs older than p_days.

Input Format

SQL procedure

Output Format

Procedure created

Example

LoginLogs(logged_at)
Procedure created

Constraints

None

Input / Output Format

Input Format
SQL procedure
Output Format
Procedure created
Constraints
None

Examples

Input:
LoginLogs(logged_at)
Output:
Procedure created

Example Solution (Public)

SQL 
CREATE PROCEDURE sp_delete_old_logs(IN p_days INT) BEGIN DELETE FROM LoginLogs WHERE logged_at < CURRENT_TIMESTAMP - INTERVAL p_days DAY; END;

Official Solution Code

CREATE PROCEDURE sp_delete_old_logs(IN p_days INT) BEGIN DELETE FROM LoginLogs WHERE logged_at < CURRENT_TIMESTAMP - INTERVAL p_days DAY; END;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.