Is there any way to implement a time based trigger in Mysql 5.1 ?

Question

Hi

Is there any way to implement a time based trigger in Mysql 5.1

i.e. it must run at 12H05 every day

Edit

A corn job calling an SQL script is currently been used - but I am looking for a less complicated solution.

Answer 1

Unless triggers in MySQL are different than in most other RDBMS, a time based trigger makes no sense. Triggers are fired in reaction to rows being added/inserted/deleted in a table. If you want a time based operation to occur, you should be considering a Job (in SQL Server) or Windows Service.