Tuesday, September 16, 2008

MySQL Scheduled Events

At the time of my undergraduate study, I had to implement a database project. In that project I had to implement a module almost like the working style of trigger just on the event of some specific time and interval. At that time I designed that module by implementing an outside program which runs as a process and at specific time it fires and manipulates some database tables.

But , today I have learned a new feature of mysql which is called Scheduled Events which runs a batch of sqls on a specific time or intervals. See the following link, how to create a scheduled event in mysql 5.1 or later version. Hope it is useful to all developers.

http://dev.mysql.com/tech-resources/articles/mysql-events.html#1

No comments: