{"id":9813,"date":"2023-01-04T07:00:00","date_gmt":"2023-01-04T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9813"},"modified":"2023-01-03T17:06:32","modified_gmt":"2023-01-03T11:36:32","slug":"cursor-in-mysql","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/cursor-in-mysql\/","title":{"rendered":"Cursor in MySQL"},"content":{"rendered":"\n<p>cursor, mysql cursor,cursor in mysql, cursors, cursor in database, create cursor in mysql, sql cursor, cursor in stored procedure, sql cursors in hindi, how to create cursor in mysql, cursor mysql, mysql cursor tutorial, cursor example in mysql prompt, cursor in stored procedure in phpmyadmin, mysql cursor example, mysql stored procedure create with cursor, cursor tutorial, cursor for<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#what-is-cursor-in-my-sql\">What is Cursor in MySQL?<\/a><\/li><li><a href=\"#use-of-cursor-in-my-sql\">Use of Cursor in MySQL<\/a><\/li><li><a href=\"#benefit-of-cursor-in-my-sql\">Benefit of Cursor  in MySQL<\/a><\/li><li><a href=\"#structure-of-cursor-in-my-sql\">Structure of Cursor in MySQL<\/a><ul><li><a href=\"#strong-declare-strong\">DECLARE <\/a><\/li><li><a href=\"#strong-open-strong\">OPEN<\/a><\/li><li><a href=\"#strong-loop-strong\">LOOP<\/a><\/li><li><a href=\"#strong-fetch-strong\">FETCH<\/a><\/li><li><a href=\"#strong-exit-logic-strong\">Exit Logic <\/a><\/li><li><a href=\"#strong-main-logic-strong\">Main Logic <\/a><\/li><li><a href=\"#strong-close-strong\">CLOSE<\/a><\/li><\/ul><\/li><li><a href=\"#cursor-syntax-in-my-sql\">Cursor Syntax in MySQL<\/a><\/li><li><a href=\"#cursor-live-example\">Cursor Live Example <\/a><\/li><li><a href=\"#strong-\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932-strong\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-cursor-in-my-sql\">What is Cursor in MySQL?<\/h2>\n\n\n\n<p>Cursor \u090f\u0915 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Tool \u0939\u0948\u0902 \u091c\u094b  \u0915\u0940 \u0906\u092a\u0915\u094b SQL \u0915\u0947 Result Set \u0915\u0940 \u090f\u0915 \u090f\u0915 Row \u092a\u0930 Operation Perform \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0938\u0941\u0935\u093f\u0927\u093e \u092a\u094d\u0930\u0926\u093e\u0928 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 Cursor \u092a\u0930 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 SQL Pass \u0915\u0930 \u0909\u0938\u0915\u0947 Result Set \u092a\u0930 Loop \u0932\u0917\u093e \u0915\u0930 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Row \u0915\u0947 Columns \u0915\u0947 Data \u0915\u094b fetch \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"use-of-cursor-in-my-sql\">Use of Cursor in MySQL<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Table \u0915\u0947 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Rows \u092a\u0930 \u0915\u094b\u0908 \u092d\u0940 Operation Perform \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e Cursor \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"benefit-of-cursor-in-my-sql\">Benefit of Cursor  in MySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u092f\u0939 \u092c\u0939\u0941\u0924 \u0939\u0940 Fast \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>Row Wise processing \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0947 validation \u092f\u093e \u0915\u094b\u0908 \u092d\u0940 calculation \u0915\u0930\u0928\u093e \u0906\u0938\u093e\u0928 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0938\u092c\u0938\u0947 \u092c\u095c\u093e Benefit \u092f\u0939 \u0939\u0948\u0902 \u0915\u0908 \u0907\u0938\u092e\u0947 \u0915\u0941\u091b Rows \u0915\u093e data \u0939\u092e\u0947 \u0926\u0947 \u0915\u0930 \u0906\u0917\u0947 \u0915\u0908 Processing \u091a\u0932\u0924\u0940 \u0930\u0939\u0924\u0940 \u0939\u0948\u0902 \u0964 \u091c\u093f\u0938\u0938\u0947 \u0939\u092e Row \u092a\u0930 Operation \u092d\u0940 Perform \u0915\u0930 \u092a\u093e\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0914\u0930 \u0906\u0917\u0947 data \u092d\u0940 load \u0939\u094b\u0924\u093e \u0930\u0939\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0939\u092e \u0905\u0928\u094d\u092f \u0930\u093f\u091c\u0932\u094d\u091f Set \u0938\u0947 compare \u0915\u0930\u0947 \u0924\u094b \u092a\u0942\u0930\u0940 SQL Execute \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u0940 \u0939\u092e Result Set \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092a\u093e\u0924\u0947 \u0939\u0948\u0902 \u091c\u092c\u0915\u093f Cursor \u092e\u0947 \u091c\u0948\u0938\u0947 \u0939\u0940 First Attempt \u092e\u0947 \u091c\u094b Rows Return \u0939\u0941\u0908 \u0939\u0948\u0902 \u0939\u092e \u0909\u0928 \u092a\u0930 Operation Perform \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0906\u0917\u0947 \u0915\u093e data load \u0939\u094b\u0924\u093e \u0930\u0939\u0924\u093e \u0939\u0948\u0902\u0964 <\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"structure-of-cursor-in-my-sql\">Structure of Cursor in MySQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>DECLARE <\/li>\n\n\n\n<li>OPEN<\/li>\n\n\n\n<li>LOOP\n<ul class=\"wp-block-list\">\n<li>FETCH<\/li>\n\n\n\n<li>Exit Logic <\/li>\n\n\n\n<li>Main Logic <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>CLOSE<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-declare-strong\"><strong>DECLARE <\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938 command \u0938\u0947 Cursor \u0915\u094b \u090f\u0915 \u0928\u093e\u092e \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 , \u0914\u0930 \u090f\u0915 SQL Pass \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u091c\u093f\u0938\u0915\u0947 Result set \u092a\u0930 \u0939\u092e\u0947 Operation Perform \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>Cursor Declare \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0947 CONTINUE HANDLER Declare \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902\u0964 \u0924\u093e\u0915\u093f Record End \u0939\u094b\u0928\u0947 \u092a\u0930 \u0939\u092e Loop \u0938\u0947 \u092c\u093e\u0939\u0930 \u0906 \u0938\u0915\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-open-strong\"><strong>OPEN<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open \u0915\u0930\u0928\u0947 \u0938\u0947 \u0939\u092e\u0928\u0947 \u091c\u094b Cursor declare \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0935\u0939 execute \u0939\u094b\u0924\u093e \u0939\u0948\u0902\u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-loop-strong\"><strong>LOOP<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Rows \u0939\u0940 Return \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0947 Loop Logic \u0932\u0917\u093e\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0939\u0940 \u0939\u092e Data \u0915\u094b Fe\u0924 ch \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 Cursor \u0915\u093e part \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u092a\u0930\u0902\u0924\u0941 \u0939\u092e\u0947 \u0907\u0938\u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u0939\u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Rows \u0915\u0947 Data \u092a\u0930 Operation Perform \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-fetch-strong\"><strong>FETCH<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938 Command \u0938\u0947 \u090f\u0915 Single Row \u0915\u0947 \u0938\u092d\u0940 Column \u0915\u0908 Value \u0915\u094b \u0939\u092e Local variable \u092e\u0947 Store \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 Local variable \u092e\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 \u0906\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e \u0909\u0928\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0905\u092a\u0928\u0947 Program Logic \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-exit-logic-strong\"><strong>Exit Logic <\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data Fetch \u0939\u094b\u0928\u0947 \u0915\u0947 Just \u092c\u093e\u0926 \u092e\u0947 \u0939\u0940 \u0939\u092e Loop \u0938\u0947 \u092c\u093e\u0939\u0930 \u0906\u0928\u0947 \u0915\u0947 Logic \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e CONTINUE HANDLER Declare \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u0924\u093e\u0915\u093f \u091c\u0948\u0938\u0947 \u0939\u0940 Rows end \u0939\u094b \u0939\u092e Loop \u0938\u0947 \u092c\u093e\u0939\u0930 \u0939\u094b \u0938\u0915\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-main-logic-strong\"><strong>Main Logic <\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0906\u092a \u091c\u093f\u0938 \u0915\u093e\u0930\u094d\u092f \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 Cursor \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 Logic \u0932\u093f\u0916\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"strong-close-strong\"><strong>CLOSE<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0915\u093e\u0930\u094d\u092f \u0938\u092e\u093e\u092a\u094d\u0924\u093f \u092a\u0930 \u0939\u092e\u0947 Cursor \u0915\u094b Close \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f Memory \u0938\u0947 Space \u0914\u0930 \u091c\u094b \u092d\u0940 Holding Cusror \u0926\u094d\u0935\u093e\u0930\u093e \u0915\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0909\u0938\u0947 free \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0947\u0964 <\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cursor-syntax-in-my-sql\">Cursor Syntax in MySQL<\/h2>\n\n\n\n<p>\u092f\u0939\u093e \u092a\u0930 MySQL \u092e\u0947 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 Cursor \u092c\u0928\u093e\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u093e Syntax \u0926\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 Cursor \u0915\u094b Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 Procedure ka \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948 \u0939\u092e Function \u092e\u0947 \u092d\u0940 Cursor \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\nCREATE PROCEDURE `ProcedureName`()\n\nBEGIN\n\n\n   DECLARE done int DEFAULT FALSE;\n\n   DECLARE CUR1 CURSOR FOR \/*Write SQL here*\/;\n   DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;\n\n\n   OPEN CUR1;\n\n  \n   lbl: LOOP\n\n       FETCH CUR1 INTO \/*Write Variable(s)*\/;\n\n       if (done) THEN\n\t   LEAVE lbl;\n       end if;\n\n\n      \n       \/*Write your Logic here*\/\n\n\n    END  LOOP;\n\n\n    CLOSE CUR1;\n\n\nEND$$\nDELIMITER ;<\/code><\/pre>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Syntax \u0938\u0947 \u0906\u092a Cursor \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0939\u092e\u0928\u0947 Procedure \u092e\u0947 Cursor \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0906\u092a \u0907\u0938\u0947 Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Call \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL ProcedureName;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cursor-live-example\">Cursor Live Example <\/h2>\n\n\n\n<p>\u0928\u0940\u091a\u0947 \u0906\u092a \u0939\u092e\u093e\u0930\u0947 Channel \u0915\u0947 Video \u0915\u0947 \u0915\u0941\u091b \u0932\u093f\u0902\u0915 \u0926\u093f\u090f \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0906\u092a Cursor \u0915\u0947 Live Example \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/youtu.be\/MPkerIkO5H4\" target=\"_blank\" rel=\"noopener\">How to Write Cursor in MySQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/7Br32MQ7oIQ\" target=\"_blank\" rel=\"noopener\">Cursor Uses | Payroll System in MySQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/__IRQCxxD_8\" target=\"_blank\" rel=\"noopener\">MySQL Payroll System (Cursor Parameter Passing) <\/a><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b\u00a0<strong>MySQL<\/strong>\u00a0Cursor \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e, \u092f\u0926\u093f \u092b\u093f\u0930 \u092d\u0940 \u0906\u092a\u0915\u0947 \u0915\u094b\u0908 Doubts \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p>\u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947, \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"strong-\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932-strong\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>cursor, mysql cursor,cursor in mysql, cursors, cursor in database, create cursor in mysql, sql cursor, cursor in stored procedure, sql cursors in hindi, how to create cursor in mysql, cursor mysql, mysql cursor tutorial, cursor example in mysql prompt, cursor in stored procedure in phpmyadmin, mysql cursor example, mysql stored procedure create with cursor, cursor [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10082,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-9813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/mysql-cursor.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=9813"}],"version-history":[{"count":84,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9813\/revisions"}],"predecessor-version":[{"id":10084,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9813\/revisions\/10084"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/10082"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}