{"id":2165,"date":"2021-08-06T18:01:42","date_gmt":"2021-08-06T12:31:42","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=2165"},"modified":"2022-07-24T21:53:17","modified_gmt":"2022-07-24T16:23:17","slug":"mysql-stored-procedure","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/","title":{"rendered":"MySQL Stored Procedure in Hindi"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u092c \u092d\u0940 \u0939\u092e\u0947\u0902 MySQL \u0915\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Statement \u0915\u093e Store \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Stored Procedure \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u090f\u0915 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Statement \u0915\u094b \u090f\u0915 Sequence \u092e\u0947\u0902 Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Stored Procedure \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><a href=\"https:\/\/youtu.be\/9jHuQ6d7te4\" target=\"_blank\" rel=\"noopener\">\u092f\u0926\u093f \u0906\u092a Video \u0926\u0947\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939\u093e\u0901 \u0938\u0947 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Advantage of MySQL Stored Procedure \u0915\u0947 \u092b\u093e\u092f\u0926\u0947 <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Stored Procedure \u0938\u0947 \u0939\u092e Select Query \u0915\u094b Run \u0915\u0930 \u0909\u0938\u0915\u0947 \u0906\u0909\u091f\u092a\u0941\u091f \u0915\u094b \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Stored Procedure \u092e\u0947\u0902 \u0939\u092e Parameter Pass \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Stored Procedure \u092e\u0947\u0902 \u0939\u092e IN\/OUT\/INOUT \u0924\u0940\u0928 \u0924\u0930\u0939 \u0938\u0947 Parameter \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Stored Procedure \u092e\u0947\u0902 \u0939\u092e Insert\/Update\/Delete SQL Command Execute \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0964<\/li><li>Stored Procedure \u092e\u0947\u0902 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 Logic \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u0907\u092f\u0947 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0939\u092e \u090f\u0915 Simple Procedure \u092c\u0928\u093e\u0928\u093e \u0938\u0940\u0916\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f Article<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\">MySQL Aggregate Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL User Define Function (UDF)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\">MySQL Trigger (Before\/After)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/update-stock-balance-using-trigger\/\">MySQL Update Stock\/Balance Using Trigger<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-introduction\/\">PHP Introduction<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-validation-filter-var-preg_match\/\">PHP Form Validations, Required, Filter<\/a>&nbsp;<\/li><li><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">SQL Logic Android App Download \u0915\u0930\u0947<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Stored Procedure Without Parameter<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 \u090f\u0915 Procedure \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u092e\u0947\u0902 \u0939\u092e\u0928\u0947 \u090f\u0915 SQL Execute \u0915\u0940 \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 \u0939\u092e\u0947\u0902 10 \u0938\u0947 \u0915\u092e Qty . \u0935\u093e\u0932\u0947 Item \u0915\u0947 Name Show \u0915\u0930\u0947\u0917\u0940 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\nDELIMITER $$\n\nCREATE PROCEDURE sp_GetMinStock () \nBEGIN\n\n  SELECT * \n  FROM mst_item\n  WHERE cl_qty &lt;= 10;\n\nEND$$\n\nDELIMITER ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0917\u093e \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL sp_GetMinStock();<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u094b \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 Output \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0939\u094b\u0917\u093e \u0964 \u092f\u0939\u093e\u0901 \u092a\u0930 Stored Procedure Execute \u0915\u0930\u0928\u0947 \u0915\u093e \u092a\u0939\u0932\u0947 \u0914\u0930 \u092c\u093e\u0926 \u0926\u094b\u0928\u094b\u0902 \u0938\u092e\u092f \u0915\u0947 Result \u0928\u093f\u091a\u0947 \u0926\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"165\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?resize=640%2C165&#038;ssl=1\" alt=\"\" class=\"wp-image-2175\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?w=811&amp;ssl=1 811w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?resize=300%2C77&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?resize=768%2C198&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?resize=465%2C120&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Stored-Procedure.jpg?resize=695%2C179&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Stored Procedure With IN Parameter <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0939\u092e\u0947\u0902 \u092a\u0939\u0932\u0947 \u090f\u0915 Fix SQL \u0932\u093f\u0916 \u0915\u0930 Procedure \u092c\u0928\u093e\u092f\u093e \u0925\u093e, \u0905\u092c \u0939\u092e\u0928\u0947 \u091c\u094b Number SQL \u092e\u0947\u0902 Fix \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 Variable \u092e\u0947\u0902 \u0932\u0947 \u0915\u0930 Parameter \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Pass \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Fixation \u0939\u092e\u093e\u0930\u0947 Stored Procedure \u092e\u0947\u0902 \u0928\u093e \u0930\u0939\u0947 \u0964IN : \u092f\u0939 Parameter \u0915\u0947 Type \u0915\u094b \u092c\u0924\u093e\u0924\u093e \u0939\u0948\u0902 , \u092f\u0939\u093e\u0901 \u092a\u0930 Parameter \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0939\u092e INPUT \u0915\u0947 \u0932\u093f\u090f \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\nDELIMITER $$\n\nCREATE PROCEDURE sp_GetMinStock (IN p_id INT(9)) \nBEGIN\n\n SELECT * \n FROM mst_item\n WHERE cl_qty &lt;= p_id;\n\nEND$$\n\nDELIMITER ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0905\u092c \u0939\u092e \u0907\u0938\u0947 Execute \u0915\u0930 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947 \u0905\u092c \u090f\u0915 Parameter Pass \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL sp_GetMinStock(20);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938\u0915\u093e output \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0939\u094b\u0917\u093e \u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"168\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?resize=640%2C168&#038;ssl=1\" alt=\"MySQL Stored Procedure With IN Parameter\" class=\"wp-image-2183\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?w=803&amp;ssl=1 803w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?resize=768%2C202&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?resize=465%2C122&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-With-IN-Parameter.jpg?resize=695%2C183&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Stored Procedure With IN &amp; OUT Parameter  <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 Example \u092e\u0947\u0902 Item Table \u0938\u0947 Item \u0915\u093e Name Display \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u0947 Procedure \u0938\u0947 Return \u0932\u0947\u0915\u0930 Select \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Show \u0915\u0930\u0947\u0902\u0917\u0947 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>IN:<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e IN \u0938\u0947 Item_id \u0915\u094b INPUT \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947 \u0930\u0939\u0947 \u0939\u0948\u0902 <strong>OUT: <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e OUT \u0938\u0947 p_nm \u092f\u093e\u0928\u093f \u0915\u0940 Item \u0915\u0947 Name \u0915\u094b OUTPUT \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0964<strong>INTO: <\/strong>\u091c\u092c \u0939\u092e\u0947\u0902 SQL \u0926\u094d\u0935\u093e\u0930\u093e Display \u0915\u093f\u092f\u0947 \u0939\u0941\u090f Column \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u0915\u093f\u0938\u0940 Variable \u092e\u0947\u0902 Store \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0924\u092c \u0939\u092e INTO \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 Item Name \u0915\u094b p_nm variable \u092e\u0947\u0902 Store \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0936\u093e \u0927\u094d\u092f\u093e\u0928 \u0930\u0916\u0947 \u0915\u0940 SQL \u0938\u0947 \u090f\u0915 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0915\u092e Row \u0939\u0940 Return \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\nCREATE PROCEDURE sp_GetItemName(IN p_id INT(9), OUT p_nm VARCHAR(40))\nBEGIN\n\n    SELECT item_nm into p_nm\n    FROM mst_item\n    WHERE item_id = p_id;\n\nEND$$\nDELIMITER ;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0905\u092c \u0907\u0938\u0947 \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Execute \u0915\u0930\u0915\u0947 \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CALL sp_GetItemName(2, @nm);\nSELECT @nm as ItemName;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u094b \u092d\u0940 mst_item \u092e\u0947\u0902 2 id \u092a\u0930 \u0921\u093e\u091f\u093e \u0939\u094b\u0917\u093e \u0935\u0939 \u0906\u092a\u0915\u094b Display \u0939\u094b \u091c\u093e\u090f\u0917\u093e <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"125\" height=\"70\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted.jpg?resize=125%2C70&#038;ssl=1\" alt=\"\" class=\"wp-image-2190\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Stored Procedure With INOUT Parameter  <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u092c \u0939\u092e\u0947\u0902 \u090f\u0915 \u0939\u0940 Parameter \u0915\u094b IN \u0914\u0930 \u0909\u0938\u0940 \u0915\u094b OUT \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c INOUT Parameter \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\n\nCREATE PROCEDURE sp_add10(INOUT i INT(9))\nset i = i + 10$$\n\nDELIMITER ;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0907\u0938 Stored Procedure \u0915\u094b Execute \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SET @v = 5;\nCALL sp_add10(@v);   \/\/15\nCALL sp_add10(@v);   \/\/25\nSELECT @V;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0902 BEGIN \u0914\u0930 END \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0939 \u0939\u092e\u0947\u0902 \u090f\u0915 \u0939\u0940 Statement \u0915\u094b Execute \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964\u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u093f\u092f\u0947 \u091c\u0939\u093e \u0938\u0947 \u0939\u092e\u0928\u0947 Input \u0915\u093f\u092f\u093e \u0935\u0939\u0940 \u0938\u0947 Output \u0939\u0940 \u0939\u094b \u0930\u0939\u093e \u0939\u0948\u0902 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"> MySQL Stored Procedure Using GUI<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>1. Click on Database&nbsp;<\/strong>: \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0915\u0947 \u0928\u093e\u092e \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/li><li><strong>2. Click on More :<\/strong>&nbsp;\u092f\u0926\u093f \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u0915\u0940 Width \u0915\u092e \u0939\u0941\u090f \u0924\u094b \u092f\u0939 Option \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e) \u0914\u0930 \u0928\u0939\u0940\u0902 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0924\u094b \u0906\u092a 3rd Step Follow \u0915\u0930\u0947 \u0964<\/li><li><strong>3.<\/strong>&nbsp;<strong>Click On Routines :<\/strong>&nbsp;\u0905\u092c \u0906\u092a Routines \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/li><li><strong>4. Add Routine<\/strong>&nbsp;: \u0905\u092c Add Routine \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"341\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?resize=640%2C341&#038;ssl=1\" alt=\"MySQL Stored Procedure GUI\" class=\"wp-image-2198\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?w=854&amp;ssl=1 854w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?resize=300%2C160&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?resize=768%2C409&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?resize=465%2C248&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Stored-Procedure-GUI.jpg?resize=695%2C370&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"541\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Add-Procedure.jpg?resize=640%2C541&#038;ssl=1\" alt=\"Add Procedure\" class=\"wp-image-2199\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Add-Procedure.jpg?w=709&amp;ssl=1 709w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Add-Procedure.jpg?resize=300%2C253&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Add-Procedure.jpg?resize=465%2C393&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Add-Procedure.jpg?resize=592%2C500&amp;ssl=1 592w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Routine Name :<\/strong>&nbsp;\u092f\u0939\u093e\u0901 \u092a\u0930 \u091c\u093f\u0938 \u0928\u093e\u092e \u0938\u0947 \u0939\u092e Procedure \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0928\u093e\u092e \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0964<\/li><li><strong>Type :&nbsp;<\/strong>\u092f\u0939\u093e\u0901 \u0938\u0947 \u0939\u092e Select \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e Function \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0915\u0940 Procedure.<\/li><li><strong>Parameter :&nbsp;<\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u094b \u092a\u0948\u0930\u093e\u092e\u0940\u091f\u0930 \u0926\u0947\u0928\u093e \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 , \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u092c \u0939\u092e \u092a\u094d\u0930\u094b\u0938\u0940\u091c\u0930 \u0915\u094b \u0915\u0949\u0932 \u0915\u0930\u0947 \u0924\u092c \u0915\u0941\u091b \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092a\u094d\u0930\u094b\u0938\u0940\u091c\u0930 \u0915\u094b Input \/ Output \u0915\u0940 \u0924\u094c\u0930 \u092a\u0930 \u0926\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 , \u0924\u094b \u0939\u092e \u091c\u093f\u0924\u0928\u0947 \u092d\u0940 Parameter \u0926\u0947\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947 \u0964<ul><li><strong>Direction :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 3 Options \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 <ul><li><strong>IN :<\/strong> \u091c\u092c \u0939\u092e\u0947\u0902 Parameter \u0915\u094b as a INPUT \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e IN \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>OUT :<\/strong> \u091c\u092c \u0939\u092e\u0947\u0902 Parameter \u0915\u094b as a OUTPUT \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e OUT \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>INOUT:<\/strong> \u091c\u092c \u0939\u092e\u0947\u0902 \u090f\u0915 \u0939\u0940 Parameter \u092e\u0947\u0902 IN and OUT \u0926\u094b\u0928\u094b\u0902 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e INOUT \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><\/ul><\/li><\/ul><ul><li><strong>Name :<\/strong>&nbsp;Parameter \u0915\u093e \u0928\u093e\u092e \u092f\u0939\u093e\u0901 \u092a\u0930 \u0932\u093f\u0916\u0947<\/li><\/ul><ul><li><strong>Type :<\/strong>&nbsp;Parameter \u0915\u093e Data Type \u092f\u0939\u093e\u0901 \u092a\u0930 \u0938\u0947 Select \u0915\u0930\u0947 \u0964<\/li><li><strong>Length :<\/strong>&nbsp;\u092f\u0939\u093e\u0901 \u092a\u0930 Width \u0932\u093f\u0916\u0947 \u0964<\/li><\/ul><\/li><li><strong>Definition :<\/strong>&nbsp;\u092f\u0939 Parameter \u0915\u0940 Body \u0939\u0948\u0902 \u0907\u0938\u0947 \u0939\u092e\u0947\u0902 BEGIN \u0938\u0947 \u0936\u0941\u0930\u0942 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 END \u0938\u0947 \u0938\u092e\u093e\u092a\u094d\u0924 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Statement \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a\u0915\u094b BEGIN\u2026.END \u0932\u0917\u093e\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>Is deterministic<\/strong>&nbsp;: \u092f\u0926\u093f \u0906\u092a\u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u092e\u0947\u0902 \u0907\u0928\u092a\u0941\u091f \u0915\u0940 Value 1 \u0939\u094b\u0928\u0947 \u092a\u0930 Return 4 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u0939\u0930 \u092c\u093e\u0930 1 input \u092a\u0930 output 4 \u0939\u0940 \u0939\u094b \u092f\u093e\u0928\u093f \u0915\u0940 Input \u0915\u093e Result \u0939\u0930 Execution \u092a\u0930 Same \u0939\u0940 \u0939\u094b \u0924\u094b \u092f\u0939\u093e\u0901 \u092a\u0930 Deterministic \u092a\u0930 Tick \u0915\u0930\u0947 \u0905\u0928\u094d\u092f\u0925\u093e \u0909\u0938\u0947 Untick \u0939\u0940 \u0930\u0939\u0928\u0947 \u0926\u0947 \u0964<\/li><li><strong>Adjust Privileges<\/strong>&nbsp;: \u092e\u0947\u0902 \u092f\u0939 \u090f\u0915 \u0928\u092f\u093e Feature \u0939\u0948\u0902, \u091c\u092c \u0906\u092a \u0915\u093f\u0938\u0940 Function \u0915\u094b Access Rights \u0926\u0947 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u092c\u093e\u0926 \u092e\u0947\u0902 \u0909\u0938\u0947 Rename \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b PHP MyAdmin \u092e\u0947\u0902 Access Rights Automatically \u0939\u0940 \u0928\u090f \u0928\u093e\u092e \u092a\u0930 Transfer \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f option Edit \u0938\u0947 open \u0915\u0930\u0928\u0947 \u092a\u0930 \u0939\u0940 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>Definer :&nbsp;<\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 User Permission \u0926\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948 \u0964<\/li><li><strong>Security Type :&nbsp;<\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u092f\u0926\u093f Definer \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0939\u0948\u0902 \u0924\u094b Function \u092c\u0928\u093e\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u0940 Access Rights \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Execution \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f INVOKER select \u0939\u0948\u0902 \u0924\u094b Execution \u0915\u0930\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u0947 Access Rights \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Execute \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>SQL Data Access :<\/strong>&nbsp;\u091c\u094b \u0939\u092e Function \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947\u0902 \u0939\u092e SQL \u0915\u093e \u0915\u093f\u0924\u0928\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0939\u092e\u0947\u0902 \u092f\u0939\u093e\u0901 \u0938\u0947 Select \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0939 Character encoding \u0915\u0947 \u0938\u092e\u092f \u0939\u0940 \u0915\u093e\u092e \u092e\u0947\u0902 \u0906\u0924\u093e \u0939\u0948\u0902 \u092f\u0926\u093f \u092f\u0939 \u0915\u094b\u0908 \u092d\u0940 \u0911\u092a\u094d\u0936\u0928 select \u0915\u0930 \u0932\u0947\u0902\u0917\u0947 \u0924\u094b \u092d\u0940 Function \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0947\u0917\u093e \u0964<strong>NO SQL :<\/strong>&nbsp;\u092f\u0926\u093f \u0906\u092a \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 SQL \u0915\u0947 Statement \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u092c NO SQL \u0932\u093f\u0916\u0947 \u0964<ul><li><strong>MODIFIES SQL DATA:<\/strong>&nbsp;\u092f\u0926\u093f \u0906\u092a INSERT UPDATE DELETE \u0906\u0926\u093f \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 \u092f\u0939 \u0935\u093e\u0932\u093e option Select \u0915\u0930\u0947 \u0964<\/li><li><strong>READS SQL DATA :<\/strong>&nbsp;\u092f\u0926\u093f \u0906\u092a \u0915\u0947\u0935\u0932 SELECT \u0915\u093e \u0939\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Option Select \u0915\u0930\u0947 \u0964<\/li><li><strong>CONTAINS SQL :<\/strong>&nbsp;\u092f\u0926\u093f \u0906\u092a SQL Statement \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0924\u094b \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0932\u0947\u0915\u093f\u0928 SELECT INSERT UPDATE DELETE \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u0930 \u0930\u0939\u0947 \u0924\u092c \u092f\u0939 \u0911\u092a\u094d\u0936\u0928 Select \u0915\u0930\u0947 \u0964<\/li><\/ul><\/li><li><strong>Comment<\/strong> : \u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a Procedure \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0915\u0941\u091b \u0928\u094b\u091f\u094d\u0938 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a Parameter \u0915\u094b <strong>Save<\/strong> \u0915\u0930\u0947 \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Stored procedure taking long time to execute mysql?<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c \u092d\u0940 \u0915\u094b\u0908 \u092d\u0940 Procedure Execute \u0939\u094b\u0928\u0947 \u092e\u0947 \u092c\u0939\u0941\u0924 \u0938\u092e\u092f \u0932\u0947 \u0924\u092c \u0906\u092a \u0928\u093f\u092e\u094d\u0928 Steps \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u091a\u0947\u0915 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902   \u0964 <\/li><li>\u092f\u0926\u093f \u0906\u092a\u0915\u0947 Procedure \u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Statement \u0939\u094b \u0924\u094b \u0906\u092a \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 \u092a\u094d\u0930\u094b\u0938\u0940\u091c\u0930 \u092e\u0947 \u0915\u0941\u091b \u0915\u0941\u091b \u0917\u0948\u092a \u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Temp \u091f\u0947\u092c\u0932 \u092e\u0947 \u090f\u0915 Temporary Insert SQL \u0932\u093f\u0916 \u0915\u0930 \u0926\u0947\u0916\u0947 \u0915\u0940 \u0915\u094c\u0928 \u0938\u0947 Statement \u092e\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0926\u0947\u0930\u0940 \u0932\u0917 \u0930\u0939\u0940 \u0939\u0948\u0902 \u0964 <\/li><li>\u0915\u094d\u092f\u093e \u0915\u094b\u0908 \u0910\u0938\u093e Statement \u0932\u093f\u0916\u093e \u0939\u0941\u0906 \u0939\u0941\u0906 \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 Dead Lock \u0915\u0940 \u0938\u094d\u0924\u093f\u0925\u093f \u092c\u0928 \u0930\u0939\u0940 \u0939\u0948\u0902 , \u092f\u093e\u0928\u093f \u0915\u0940 \u0915\u093f\u0938\u0940 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0915\u094b\u0908 Lock \u0932\u0917\u093e \u0939\u0948\u0902 \u0914\u0930 \u0939\u092e \u0909\u0938\u092e\u0947 \u0915\u094b\u0908 Insert \u092f\u093e Alter SQL \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 Lock \u0939\u094b\u0928\u0947 \u0915\u0947 \u0915\u093e\u0930\u0923 \u0926\u0947\u0930\u0940 \u0932\u0917\u0947\u0917\u0940 \u0964 <\/li><li>\u0906\u092a\u0928\u0947 \u091c\u094b \u092d\u0940 SQL \u0932\u093f\u0916\u0940 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0926\u0947\u0916\u0947 \u0915\u0940 \u0909\u0938\u0915\u0947 \u0915\u093e\u0930\u0923 \u092f\u0926\u093f \u0926\u0947\u0930\u0940 \u0939\u094b \u0930\u0939\u0940 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a SQL \u0915\u094b Correct \u0915\u0930\u0947 \u0964 <\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Advantage of MySQL Stored Procedure \u0915\u0947 \u092b\u093e\u092f\u0926\u0947 Stored Procedure \u0938\u0947 \u0939\u092e Select Query \u0915\u094b Run \u0915\u0930 \u0909\u0938\u0915\u0947 \u0906\u0909\u091f\u092a\u0941\u091f \u0915\u094b \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 Stored Procedure \u092e\u0947\u0902 \u0939\u092e Parameter Pass \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 Stored Procedure \u092e\u0947\u0902 \u0939\u092e IN\/OUT\/INOUT \u0924\u0940\u0928 \u0924\u0930\u0939 \u0938\u0947 Parameter \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 Stored Procedure \u092e\u0947\u0902 \u0939\u092e Insert\/Update\/Delete SQL Command [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2212,"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-2165","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\/2021\/08\/mysql-stored-procedure.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2165","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=2165"}],"version-history":[{"count":48,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2165\/revisions"}],"predecessor-version":[{"id":8737,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2165\/revisions\/8737"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/2212"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=2165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=2165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=2165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}