CODEWITHSUNDEEP
mysql
Preethi
Preethi

Reputation: 120

event scheduler with declare statement

Is it possible to create a event scheduler with declare statement in it?

i have been trying run this query without any success

create event dele on schedule
every 1 day 
do
begin
declare c int; 
select count(*) into c from purchased;
if(c > 5) 
delete from purchased limit 2
end if;
end

Upvotes: 0

Views: 1958

Answers (1)

Omesh
Omesh

Reputation: 29121

This is because you are missing THEN after IF. See manual here

try this:

delimiter |

CREATE EVENT dele
    ON SCHEDULE EVERY 1 DAY
    DO
    BEGIN
        DECLARE c INT;

        SELECT COUNT(*) INTO c
        FROM purchased;

        IF(c > 5)
        THEN
            DELETE FROM purchased LIMIT 2;
        END IF;
END |

delimiter ;

Upvotes: 1

Related Questions