From: Martijn Tonies
Date: November 1 2006 4:58pm
Subject: Re: Automatic Removal
List-Archive: http://lists.mysql.com/mysql/203067
Message-Id: <02b901c6fdd6$ed19fd90$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> got a Really Simple question, which is probably really easy, but it's 
> just not starign me in the face.
> 
> Is there any "query" in MYSQL (or function in PHP that works with MYSQL) 
> to remove a value from a field when a new week comes across, or to 
> remove something from a field on a defined date and time, automatically?

Depends on your definition of "automatically" :-)

MySQL 5.1 has "Events": a server side process checks periodically to see
if anything needs to be done, for example, your delete/clear SQL statement.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com