Lee Lee
Reputation: 583
MySQL: Delete all rows older than 20 Hours
I have a timestamp field in my table. How do I delete records older than 20 hours old?
My query is : DELETE FROM tickets WHERE timestamp < (NOW() - INTERVAL 20 HOUR)
Question: Is above query is correct?
Upvotes: 4
Views: 5540
Answers (1)
Related Questions
- MySQL: Delete all rows older than 10 minutes
- Delete records older than 24 hours or 1 day based on timestamp
- Delete all rows with timestamp older than x days
- MySQL Delete Records Older Than X Minutes?
- sql delete all rows older than 30 days
- How to delete data which is older than 30 minutes or 24 hours from mysql table using php
- MySQL delete older then * hours
- PHP MySQL Delete Rows older than 1 minute
- Delete rows older than 30 minutes in MySQL
- Delete MySql Records older than a half hour or 1800 seconds?