Error when creating a trigger

Question

Error when creating a trigger

Navigation

#1 by (0 votes)

0

I'm creating this trigger

DELIMITER // 
CREATE TRIGGER reposta3A   
AFTER INSERT ON utilizacao_veiculo
FOR EACH ROW    
BEGIN           
SELECT emite_mensagem();
END//
DELIMITER ;

but when I run the show triggers command; it does not appear as if it was created

mysql mysql-workbench

asked by anonymous 13.06.2017 / 17:22

1 answer

Date and time of modification of files to download a site in wordPress Best way to use Foreach

score 0 · Answer 1

I think your problem is with the creation of the trigger, try to execute this query to create the trigger:

DELIMITER $$

CREATE

    TRIGGER 'reposta3A' AFTER INSERT ON 'utilizacao_veiculo' 
    FOR EACH ROW BEGIN
        SELECT emite_mensagem();
    END;
$$

DELIMITER ;