Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC 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
Bookmark "Delete Expired Rows?" Watch "Delete Expired Rows?" New topic
Author

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,
Drew
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.


Bosun (SCJP, SCWCD)
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.
 
wood burning stoves
 
subject: Delete Expired Rows?
 
Similar Threads
Hibernate not deleting rows
Removing rows from a default table model
communication between servlets & JSPs
Displaying an additional row in a jtable
delete sql not working