Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE TRIGGER tr_updStockExcedente AFTER INSERT ON detallerea
- FOR EACH ROW BEGIN
- UPDATE excedentes SET stock = stock - NEW.cantidad
- WHERE excedentes.idexcedente =NEW.idexcedente;
- END
- //
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement