Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 KB | None | 0 0
  1. DELIMITER //
  2. CREATE TRIGGER OQminusPQ
  3.   AFTER INSERT ON orders
  4.   FOR EACH ROW
  5. BEGIN
  6.   DECLARE PQMOQ INT;
  7.   SELECT products.Quantity - orders.Quantity
  8.     INTO PQMOQ
  9.     FROM products
  10.     WHERE products.ProductID = orders.ProductID;
  11.  
  12. END //
  13. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement