Advanced Search

Manejo de Cursores en SP en MYSQL

/ Published in: MySQL
Save to your folder(s)
Esquema basico de manejo de cursores en MYSQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE DEFINER=`root`@`localhost` PROCEDURE `myprocedure`()
  2. BEGIN
  3.  
  4. DECLARE done BOOLEAN DEFAULT FALSE;   -- VARIABLE DE CONTROL
  5. DECLARE c1 CURSOR FOR /* SENTENCIA SQL */;  -- DECLARACION CURSOR
  6. DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = TRUE;  -- MANEJADOR EVENTOS
  7.  
  8. OPEN c1;  //ABRIMOS EL CURSOR
  9.   c1_loop: LOOP FETCH c1 INTO /* AQUI VARIABLES QUE TOMAN EL VALOR DE CURSOR*/;  
  10.     IF `done` THEN LEAVE c1_loop; END IF;  // FINALIZA EL CICLO SI EL EVENTO INDICA QUE NO HAY REGISTROS 
  11.         -- AQUI SENTENCIAS INTERNAS AL CICLO
  12.     END LOOP c1_loop;  // LOOP CURSOR
  13.     CLOSE c1;    // CERRAMOS CURSOR
  14.  
  15.  
  16. END

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.