File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Delete Expired Rows? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Delete Expired Rows?" Watch "Delete Expired Rows?" New topic

Delete Expired Rows?

Drew Lane
Ranch Hand

Joined: May 13, 2001
Posts: 296
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,
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
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.

So much trouble in the world -- Bob Marley
sharad goswami
Ranch Hand

Joined: Jan 18, 2001
Posts: 51
program it...

Stop The World I Want To Get Off.
I agree. Here's the link:
subject: Delete Expired Rows?
It's not a secret anymore!