How to automate a mysql query?

Question

MySQL

Hello.
I’ll make a reservation right away, I’m new to the topic, I re-read a bunch of literature, there’s a mess in my head and understanding of the essence didn’t come =(.
There is a request in a text file of the following form -
UPDATE `zero-actual-dump`.`wp_usermeta` SET `meta_value`=' online' WHERE `umeta_id`=7658;
It is necessary that this query be processed automatically 3 times a day (09, 12 and 16 hours) Ubuntu server system, mysql
Please tell me how to implement this?

Answer 1

If it is by means of MySQL, then there are events (events) with which this can be done
https://dev.mysql.com/doc/refman/8.0/en/event-sche...

Answer 2

cron