how to declare variable in mysql trigger -

this trigger

create trigger proximo_pago  after insert on pago each row begin     declare max_orden integer;     declare num_lote =new.lote;         begin             set max_orden = (select max(orden) pago lote=num_lote);             select max_orden : new.orden dual;             end end 

and error

error sql query:

create trigger proximo_pago  after insert on pago each row begin     declare max_orden integer; 

mysql said: documentation

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 4

 declare tempkode varchar(10);  declare temp varchar(5); 

or if want assign can use

 declare temp int default 6; 

to assign variable

myvariable := tempkode; set myvariable := tempkode; 

maybe mean :

create trigger proximo_pago  after insert on pago each row begin declare max_orden int; declare num_lote int;     begin         set num_lote := new.lote;         select max(ordern) max_ordern pago lote = num_lote;         set new.ordern := max_ordern;  end