I have a working command:
UPDATE ads SET ad_points = ad_points - 20
And I would like to perform this action every day.
After creating the event in phpMyAdmin (MYSQL) nothing happens (on the next day, etc.):
CREATE EVENT daily_pointsmin ON SCHEDULE EVERY 1 DAY COMMENT 'Subtracts twenty points from all the ads on every day.' DO UPDATE ads SET ad_points = ad_points - 20;
What can be the reason? The DB is in MYISAM, the tables are in InnoDB.
I've tried this already (including db in code):
UPDATE indikatr_main.ads SET ad_points = ad_points - 20