Advanced Search

MANEJO CURSOR MYSQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DECLARE idone INT DEFAULT 0;
  2. /* Incluir aqui Todas las variables del cursor*/
  3.  
  4. DECLARE docs CURSOR FOR  /* añadir aqui la sentencia SQL */ ;
  5.  
  6. DECLARE CONTINUE HANDLER FOR NOT FOUND SET idone = 1; 
  7.  
  8. OPEN docs;
  9. REPEAT
  10. FETCH docs INTO /* asignacion valores cursor a variables  */ ;
  11. IF NOT idone THEN
  12.    /* INCLUIR AQUI TODO EL CODIGO PARA CADA REGISTRO DEL CURSOR */
  13. END IF;
  14. UNTIL idone END REPEAT;
  15. CLOSE docs;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.