> 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.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!
|• Automatic Removal||Richard Harris||1 Nov|
| • Re: Automatic Removal||Martijn Tonies||1 Nov|