Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE TRIGGER OQminusPQ
- AFTER INSERT ON orders
- FOR EACH ROW
- BEGIN
- DECLARE PQMOQ INT;
- SELECT products.Quantity - orders.Quantity
- INTO PQMOQ
- FROM products
- WHERE products.ProductID = orders.ProductID;
- END //
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement