Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. CREATE TRIGGER `increment_goods_count` AFTER INSERT ON `supply`
  2.  FOR EACH ROW BEGIN
  3. UPDATE goods SET
  4. `goods`.`count` = `goods`.`count` + NEW.`count`,
  5. `goods`.`price` = new_price(NEW.`initial_price`)
  6. WHERE `goods`.`id_goods` = NEW.`id_goods`;
  7. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement