Error while creating MySql event scheduling for a specific period of time everyday with an interval of i hour

Question

Error while creating MySql event scheduling for a specific period of time everyday with an interval of 1 hour.

My code are

CREATE EVENT your_event ON SCHEDULE 
   EVERY 30 MINUTE
   STARTS '2013-10-01 10:00:00'
DO
  IF time(CURRENT_TIMESTAMP) between time('10:00:00') and time('18:00:00')
  then
        INSERT INTO andrew (name) values ('test')
  end if

and the error is:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end if' at line 8

You missed the query terminator `;` in the end of the `INSERT` and `END IF` statements — Arulkumar, Jun 20 '16 at 10:42
Even after giving end the statement with ;, problem were same. — Diwakar Kumar, Jun 20 '16 at 11:20

score 0 · Accepted Answer · answered Jun 20 '16 at 10:36

0

Try this;)

DELIMITER $$ 

CREATE EVENT your_event ON SCHEDULE 
   EVERY 30 MINUTE
   STARTS '2013-10-01 10:00:00'
DO
IF time(CURRENT_TIMESTAMP) BETWEEN time('10:00:00') AND time('18:00:00') THEN
    INSERT INTO andrew (name) VALUES ('test');
END IF $$

DELIMITER ;

answered Jun 20 '16 at 10:36

Blank

12,308
1
14
32

Thanks Sir! You did it... Since morning I was googling for same but finally you did it... Thanks again... Its now working fine. – Diwakar Kumar Jun 20 '16 at 11:23
This query is running successfully but when i check the event list, no any event were created – Diwakar Kumar Jun 20 '16 at 12:19
I've tried this query, and it really created a event. :( – Blank Jun 21 '16 at 01:35
Yes last I tried it on workbench i worked fine. There was problem with old version of XAMPP. – Diwakar Kumar Jun 21 '16 at 04:19

Error while creating MySql event scheduling for a specific period of time everyday with an interval of i hour

1 Answers1