This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Delete Expired Rows?

 
Drew Lane
Ranch Hand
Posts: 296
  • 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: 1511
  • 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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
program it...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic