开发者

SQL repeat events by timer

I want that a column of my database, composed by float random numbers, change every x seconds determined by a timer开发者_StackOverflow社区.

I read about Schedule Tasks Events but i can't work it.

Please help


The following statement solve part of the problem, i hope it will be useful for others users:

CREATE EVENT addTimer 
ON SCHEDULE EVERY 2 SECOND 
STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 9 HOUR 
DO 
UPDATE prova.prova SET actual = actual + 1


I'm only familiar with sql server, but could you set up a stored proc with an infinite loop and a wait?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜