Skip to content

Instantly share code, notes, and snippets.

@appkr

appkr/auto_prune_old_database_records_with_mysql_event.md

Created May 31, 2019 08:23
Show Gist options
  • Save appkr/efdfb0dd9232a7e64339cb31bcaeb2fb to your computer and use it in GitHub Desktop.
Save appkr/efdfb0dd9232a7e64339cb31bcaeb2fb to your computer and use it in GitHub Desktop.
Download ZIP
Auto prune old database records with MySQL event
Raw
auto_prune_old_database_records_with_mysql_event.md 
CREATE EVENT AutoDeleteOldNotifications
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY 
ON COMPLETION PRESERVE
DO 
DELETE LOW_PRIORITY FROM databaseName.tableName WHERE datetime < DATE_SUB(NOW(), INTERVAL 30 DAY)

source: https://stackoverflow.com/a/13009906

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment