CODEWITHSUNDEEP
mysqltriggers
Fahad.ag
Fahad.ag

Reputation: 181

Cant get Mysql trigger statement right

Can someone please tell me whats wrong with this trigger statement?

DELIMITER //

CREATE TRIGGER something AFTER INSERT ON sometable
FOR EACH ROW
BEGIN
DECLARE var INT DEFAULT 0;
SET var = SELECT COUNT(*) FROM anothertable;
IF var=0 THEN
INSERT INTO anothertable values(`x`,`y`,`z`);
END IF;
END//

I keep getting error saying i have syntax errors...

Upvotes: 0

Views: 95

Answers (1)

Gerd Riesselmann
Gerd Riesselmann

Reputation: 986

Try putting the SELECT statement within brackets:

DELIMITER //

CREATE TRIGGER something AFTER INSERT ON sometable
FOR EACH ROW
BEGIN
    DECLARE var INT DEFAULT 0;
    SET var = (SELECT COUNT(*) FROM anothertable);
    IF var=0 THEN
        INSERT INTO anothertable values('x','y','z');
   END IF;
END//

Upvotes: 1

Related Questions