Advertisement
alexx876

Untitled

Jun 24th, 2021
918
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. DELIMITER $$
  2. CREATE TRIGGER `returnMoney` before delete ON `likes`
  3. FOR EACH ROW BEGIN
  4.     UPDATE users SET money = money + (OLD.count-OLD.done)*OLD.price
  5.     WHERE users.id = OLD.user_id;
  6. END$$
  7. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement