Advanced Search

Return to Snippet

Revision: 50395
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
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