Hi,
I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring.
Cookies don't "delete themselves" after expiring. Something (e.g., a browser) notices that they've reached their expiration time and deletes them.
Rows don't automatically expire in MySQL. You run a query to identify expired rows and delete them. Depending on your operating system, you might be able to schedule a job that runs periodically to perform this task, which is in most respects what you appear to want. For example, on Unix you can schedule a cron job.
Thanx for the info
Anthony
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
