MySQL Erro Mysql Workbech, Error 1422

[CamBroBr]

 

DELIMITER //

create trigger att_qtdlixpl after insert
on tbl_viagem
for each row
BEGIN
start transaction;
select fk_plan_id into @w_fk_plan_id from tbl_viagem;
select via_qtd into @w_via_qtd from tbl_viagem;
select plan_qtdlixo into @w_plan_qtdlixo from tbl_planetas;

update tbl_planetas
set plan_qtdlixo = (@w_plan_qtdlixo + @w_via_qtd)
where plan_id = @w_plan_id;
commit;
END//
DELIMITER ;

 

Error Code: 1422. Explicit or implicit commit is not allowed in stored function or trigger.

[Horse With No Name]

Tem um erro na sua logica de reversão, tenta mudar ela de lugar