Posted By

georgemathewkunnathoor on 08/19/11


Tagged


Versions (?)

Executing Stored Procedure sp_rent


 / Published in: SQL
 

  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  

You need to login to post a comment.