Advertisement
Bazze

Untitled

Oct 9th, 2012
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.29 KB | None | 0 0
  1. DELIMITER //
  2. CREATE TRIGGER updateTotalPrice AFTER INSERT ON `OrderLine` FOR EACH ROW
  3.     BEGIN
  4.         UPDATE `CustomOrder`
  5.             SET `TotalPrice` = `TotalPrice` + (
  6.                 SELECT a.`Price`*ol.`Amount` FROM `Article` a WHERE a.`Nr` = NEW.`ArtNr`
  7.             )
  8.         WHERE `Nr` = NEW.`OrderNr`;
  9.     END //
  10. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement