Advertisement
alexx876

Untitled

Jun 24th, 2021
868
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.19 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.price
  5. WHERE users.id = OLD.user_id;
  6. END$$
  7. DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement