Advanced Search

Return to Snippet

Revision: 22030
at December 29, 2009 09:44 by xaviles
Initial Code 
DECLARE idone INT DEFAULT 0;
/* Incluir aqui Todas las variables del cursor*/

DECLARE docs CURSOR FOR  /* añadir aqui la sentencia SQL */ ;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET idone = 1; 

OPEN docs;
REPEAT
FETCH docs INTO /* asignacion valores cursor a variables  */ ;
IF NOT idone THEN
   /* INCLUIR AQUI TODO EL CODIGO PARA CADA REGISTRO DEL CURSOR */
END IF;
UNTIL idone END REPEAT;
CLOSE docs;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Esquema basico manejo cursores  en MYSQL

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MANEJO CURSOR MYSQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL