• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Delete Expired Rows?

 
Drew Lane
Ranch Hand
Posts: 296
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm looking to delete rows in my relational
database (mysql) upon a certain expiration date
(say, 30 days after the original data was entered)
Any ideas on the best way to do this?
Do databases typically have this feature built in
or is it something you have to program?
Thank you,
Drew
 
Bosun Bello
Ranch Hand
Posts: 1510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This will depend on the DB. You can write a stored procedure that will have to be executed to delete rows that meet your criteria.
 
sharad goswami
Ranch Hand
Posts: 51
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
program it...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic