Error when creating a Trigger

Asked

Viewed 113 times

0

I’m creating this Rigger

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

but when I execute the show triggers command; she doesn’t appear as if she were created

mysql mysql-workbench

1 answer

0

I believe your problem is with the creation of Trigger, try running this query to create Trigger:

DELIMITER $$

CREATE

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

DELIMITER ;

  • still doesn’t show how a Rigger created

  • some error when you execute this query I gave you?

  • there is no mistake, it simply does not create Trigger

Browser other questions tagged mysql mysql-workbench

You are not signed in. Login or sign up in order to post.