G
G
Groofy2017-09-15 13:44:37
PHP
Groofy, 2017-09-15 13:44:37

How to change data in mysql cell using cron?

Subject!
There is a mysql table row
every day the cell data is updated
. A crutch is needed, the point is to change the value of one of the cells to a certain static

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Alexander Chernykh, 2017-09-15
@sashkets

mysql has its own scheduler and procedures. Use them without third party software

V
Vladimir Skibin, 2017-09-15
@megafax

Write this request in a script and just call it with cron. Or is the task description incomplete?

F
Fortop, 2017-09-15
@Fortop

https://dev.mysql.com/doc/refman/5.7/en/events-pri...

CREATE EVENT e_store_ts
    ON SCHEDULE
      EVERY 10 SECOND
    DO
      INSERT INTO myschema.mytable VALUES (UNIX_TIMESTAMP());

What's the question?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question