hristocr

Untitled

Oct 15th, 2018
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. CREATE PROCEDURE usp_withdraw_money(account_id INT, money_amount DECIMAL(38,4))
  2. BEGIN
  3. START TRANSACTION;
  4. UPDATE accounts a
  5. SET a.balance = a.balance - money_amount
  6. WHERE a.id = account_id;
  7. IF (SELECT a.balance FROM accounts a WHERE a.id=account_id) >= 0
  8. THEN COMMIT ;
  9. ELSE
  10. ROLLBACK ;
  11. END IF;
  12. END;
Advertisement
Add Comment
Please, Sign In to add comment