co tak nato pouzit mysql event to ti staci zadat interval a cas konca a prislusne prikazy na zmenu riadkov tabulky
Kód:
delimiter |
CREATE EVENT up_building
ON SCHEDULE
EVERY 5 MINUTE ENDS NOW() + INTERVAL 15 MINUTE
COMMENT 'zvysi budovu kazdych 5 minut'
DO
BEGIN
UPDATE budova bal bla bal
END |
delimiter ;