I wanted to execute the query stored in a table with given intervals.
I have a table called "calculations". it has the following structure:
id | period | sql | result |
now, in the sql field, I store the sql clause to be executed. In the period field, there is time interval for the query to run. Result field stores the result of the sql clause.
1 | 5 | select count(*) from mytable | 1
this means that every 5 minutes, take the given query, execute it, and update the result field.
I could not find a way to do this.