Mysql Trigger syntax error

Question

I tried to create the Trigger below in phpMyAdmin, but returns the following error:

Messages from Mysql :

1064 - You have a syntax error in your SQL next to '' on line 4

Someone’s been through it or would know to help me?

create trigger trg_pagamento before insert on entrega
for each row 
begin
declare pagto int DEFAULT 0;
    select p.cod_status
    into pagto 
    from pagamento p
    where p.cod_pedido = new.cod_pedido;  
    if pagto != 3 then
        null;
    end if;
end;

Answer 1

The error happens because you did not use the mysql instruction delimiter, so when you arrive at ; (semicolon) line 4 mysql understands that the command is terminated and that there is no need for continuity.

DELIMITER //

-- seu script

//
DELIMITER ;

So mysql will run everything between //.