Is there such a possibility, as changing some field in the database table after some time, using sql tools? For example: changing some value of a table field in a week, and a week later.

  • one
    only through task schedulers, external (cron) or internal (event). But it is better to design the database so that there is no need to change anything in time - Mike
  • @ andrew-dmitriev which version of MySQL do you use? - Alexander Bragin
  • @Mike yes, it’s a pity that it’s not always possible in reality - Andrew Dmitriev

1 answer 1

Task Scheduler, here is an example http://blog.nagaychenko.com/2009/11/30/scheduler-%D0%B8%D0%BB%D0%B8-event-%D0%B2-mysql-%D0%BF% D0% BB% D0% B0% D0% BD% D0% B8% D1% 80% D0% BE% D0% B2% D1% 89% D0% B8% D0% BA-% D0% B7% D0% B0% D0 % B4% D0% B0% D0% BD% D0% B8% D0% B9-% D0% B0% D0% BB% D1% 8F-cron / if there are some "after some time" after, for example, adding records, we make a separate auxiliary table to control the execution of tasks by the scheduler.

  • Thank you, I didn’t even know about such a feature) - Andrew Dmitriev