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
posted 15 years ago
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