Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter $$
- create trigger Atualiza_Pedido
- after insert on loja.pedido for each row
- Begin
- if new.method = 'metodo'
- then
- update loja.pedido
- set tipo = concat(new.quantidade,'-', new.tipo)
- where id = new.id;
- end if;
- END$$
- delimiter $$
- create trigger Atualiza_Pedido
- before insert on loja.pedido for each row
- Begin
- if new.method = 'metodo' then
- set new.tipo = concat(new.quantidade,'-', new.tipo);
- end if;
- END$$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement