CODEWITHSUNDEEP
mysqlsqleventsscheduler
Question-er XDD
Question-er XDD

Reputation: 767

MySQL- How to implement event scheduler everyday + start from 8am to 10 pm+ every 15 min

I would like to insert the statistic into table 1 every 15 min start from 8am to 10pm everyday

How to use MySQL event scheduler to do it? 

delimiter ||
    CREATE EVENT STOCK_UPDATER
        ON SCHEDULE EVERY 15 MINUTE 
            DO BEGIN
                [INSERT CODE THAT I HAVE MADE]
    END ||
delimiter ;

======================================

Thz @Saharsh Shah, I finally solve it, here are my final result:

create table ABC (value int(10));

DELIMITER $$

CREATE EVENT ABCevents 
   ON SCHEDULE EVERY 15 SECOND 
        DO BEGIN
                IF (HOUR(SYSDATE()) BETWEEN 14 AND 15) THEN
                    insert ABC value(123);
                END IF;
        END $$
DELIMITER ;

Upvotes: 1

Views: 1113

Answers (1)

Saharsh Shah
Saharsh Shah

Reputation: 29051

Try this: 

DELIMITER $$

CREATE EVENT STOCK_UPDATER 
   ON SCHEDULE EVERY 15 MINUTE 
      STARTS '2013-11-27 12:00:00' ON COMPLETION NOT PRESERVE ENABLE 
         DO BEGIN
    IF (HOUR(SYSDATE()) BETWEEN 8 AND 22) THEN 
    BEGIN 
         INSERT ABC VALUES (123);
    END IF;
END$$

DELIMITER ;

Upvotes: 2

Related Questions