How to delete a MySQL record after a certain time

by

You can try using this condition:

WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY)

So that the whole SQL script looks like this:

CREATE EVENT delete_event
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
ON COMPLETION PRESERVE

DO BEGIN
      DELETE messages WHERE date < DATE_SUB(NOW(), INTERVAL 7 DAY);
END;

However, on your place I would solve the given problem with a simple cron script. The reasons to do this is simple: it’s easier to maintain the code, no ugly SQL workarounds, integrates smoothly with your system.

More Related Contents:

  1. How to use IN & NOT IN same query [closed]
  2. MySQL: Large VARCHAR vs. TEXT?
  3. MySQL: is a SELECT statement case sensitive?
  4. Check overlap of date ranges in MySQL
  5. 1114 (HY000): The table is full
  6. UPDATE multiple tables in MySQL using LEFT JOIN
  7. How to raise an error within a MySQL function
  8. Multiple-column foreign key in MySQL?
  9. What is maximum query size for mysql?
  10. Finding all parents in mysql table with single query (Recursive Query)
  11. Get the latest date from grouped MySQL data
  12. How do I retrieve my MySQL username and password?
  13. How to execute a MySQL command from a shell script?
  14. Select most common value from a field in MySQL
  15. MySQL update a joined table
  16. MySQL join query using like?
  17. MySQL: When is Flush Privileges in MySQL really needed?
  18. MySQL: update a field only if condition is met
  19. MySql Query: Select top 3 rows from table for each category
  20. how to use DISTINCT ON with mysql using ActiveRecord
  21. Split a string and loop through values in MySQL stored procedure
  22. MySQL Select Query – Get only first 10 characters of a value
  23. Create an index on a huge MySQL production table without table locking
  24. MySQL concurrency, how does it work and do I need to handle it in my application
  25. mysql select id and name from other table and join query
  26. Query to count the number of tables I have in MySQL
  27. `MODIFY COLUMN` vs `CHANGE COLUMN`
  28. INSERT INTO Table from multiple tables
  29. Mysql How do you create a clustered index?
  30. Counting associated entries with Sequelize

Leave a Comment