Mysql trigger - Syntax error

Question

Would anyone know where I’m going wrong Trigger down below?

CREATE TRIGGER atualiza_produto 
AFTER INSERT 
ON item_venda FOR EACH ROW
BEGIN
UPDATE produto SET vendido = 's' WHERE id = NEW.id_produto;
END

The error message:

Você tem um erro de sintaxe no seu SQL próximo a '' na linha 5

Answer 1

The MySql has the ; end of each query, in which case he’s trying to execute two querys rather than one, precisely because the ; is separating.

To prevent this from happening, it is necessary to show MySql what the ; is not finalizing the query and yes it is part of the context, for that there is the DELIMITER, in your case would look like this:

DELIMITER $$
    CREATE TRIGGER atualiza_produto AFTER INSERT ON item_venda FOR EACH ROW
    BEGIN
        UPDATE produto SET vendido = 's' WHERE id = NEW.id_produto;
    END
$$

Anything that stands between DELIMITER $$ and $$ shall be executed jointly and not by separating querys each ;.

See more here.