Advanced Search

Executing Stored Procedure sp_rent

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. mysql>CALL rent(‘The Hurt Locker’,1,1,@STATUS,@dno);
  2. mysql>SELECT @STATUS;
  3. +———————————+
  4. | @STATUS |
  5. +———————————+
  6. | DVD(301) IS rented successfully |
  7. +———————————+
  8. 1 ROW IN SET (0.00 sec)
  9.  
  10. mysql>SELECT @dno;
  11. +——————+
  12. | @dno |
  13. +——————+
  14. | 301 |
  15. +——————+
  16. 1 ROW IN SET (0.00 sec)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.