Periodic SQL query

Question

Tell me how to make a periodic SQL query, say, to be executed once a day?

thanks - you can answer, I will choose as the correct answer
@Semen Savenko, If you are given an exhaustive answer, mark it as correct (click on the check mark next to the selected answer).
I know how to choose the right answer - but the speaker just wrote it in a comment
@Seven Savenko, a comment about the check mark next to the answer was written after I converted the comment into an answer, so that the message fell on your soap and you entered the question :)

Denis Khvorostin Denis Khvorostin 4.391 four thirty 74 · Accepted Answer · 2013-08-20T09:10:31

cheops cheops 18.1k 9 32 120 · Answer 2 · 2016-05-11T20:28:26

To do this, you can use the MySQL event mechanism (EVENT)

CREATE EVENT `myevent` ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE tbl SET tiq = tiq + 1;

2 answers 2