Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER //
- CREATE TRIGGER updateTotalPrice AFTER INSERT ON `OrderLine` FOR EACH ROW
- BEGIN
- UPDATE `CustomOrder`
- SET `TotalPrice` = `TotalPrice` + (
- SELECT a.`Price`*ol.`Amount` FROM `Article` a WHERE a.`Nr` = NEW.`ArtNr`
- )
- WHERE `Nr` = NEW.`OrderNr`;
- END //
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement