Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELIMITER $$
- CREATE TRIGGER `returnMoney` before delete ON `likes`
- FOR EACH ROW BEGIN
- UPDATE users SET money = money + (OLD.count-OLD.done)*OLD.price
- WHERE users.id = OLD.user_id;
- END$$
- DELIMITER ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement