skakar liv i en gammal tråd bara för att säga att event scheduler i mysql5.1 verkar vara bra. den i kombination med en view gör nog ungefär vad jag är ute efter.
Citat:
|
Event scheduler. MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Conceptually, this is similar to the idea of the Unix crontab (also known as a “cron job”) or the Windows Task Scheduler. See Chapter 20, Event Scheduler. (Author: Andrey Hristov)
|