Revision: 50395
Updated Code
at August 19, 2011 15:51 by georgemathewkunnathoor
Updated Code
mysql>CALL rent(‘The Hurt Locker’,1,1,@status,@dno); mysql>SELECT @status; +———————————+ | @status | +———————————+ | DVD(301) IS rented successfully | +———————————+ 1 row IN SET (0.00 sec) mysql>select @dno; +——————+ | @dno | +——————+ | 301 | +——————+ 1 row IN SET (0.00 sec)
Revision: 50394
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 19, 2011 15:46 by georgemathewkunnathoor
Initial Code
call rent(‘The Hurt Locker’,1,1,@status,@dno); select @status; +———————————+ | @status | +———————————+ | DVD(301) is rented successfully | +———————————+ 1 row in set (0.00 sec) mysql>select @dno; +——+ | @dno | +——+ | 301 | +——+ 1 row in set (0.00 sec)
Initial URL
Initial Description
Initial Title
Executing Stored Procedure sp_rent
Initial Tags
Initial Language
SQL