{"id":2122,"date":"2021-08-04T21:45:02","date_gmt":"2021-08-04T16:15:02","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=2122"},"modified":"2022-02-25T17:18:16","modified_gmt":"2022-02-25T11:48:16","slug":"mysql-function","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-function\/","title":{"rendered":"MySQL Function (UDF) User Define Function in Hindi"},"content":{"rendered":"\n<p>\u0907\u0938 Article \u092e\u0947 \u0939\u092e MySQL Function  \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0947\u0902\u0917\u0947 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947 \u0915\u0948\u0938\u0947 \u0939\u092e <strong>UDF<\/strong> (User Define Function) \u0932\u093f\u0916\u0928\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-function-\u0915-\u092f-\u0939-\u0924-\u0939\">MySQL Function \u0915\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 ?<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e \u0915\u094b\u0908 \u092d\u0940 \u0915\u093e\u0930\u094d\u092f \u092f\u093e SQL Query \u0915\u094b \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u092c\u093e\u0930 \u090a\u092a\u092f\u094b\u0917 \u092e\u0947 \u0932\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e Query \u0915\u094b Function \u092e\u0947 \u0932\u093f\u0916\u0947 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 , \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u0939\u092e\u0947 \u091c\u092c \u0909\u0938 Query \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0917\u0940 \u091c\u092c \u0939\u092e Function \u0915\u094b call \u0915\u0930 \u0932\u0947\u0902\u0917\u0947\u0964  Function \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e Single Value Return \u0932\u0947 \u0938\u0915\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">User Define Function Meaning in Hindi <\/h2>\n\n\n\n<p>User Define \u0915\u093e \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947 \u092e\u0924\u0932\u092c \u092f\u0939 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e \u0905\u092a\u0928\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u0940 Function \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948 , user function \u0915\u094b \u0916\u0941\u0926 Define \u0915\u0930 \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u0940 \u0907\u0938\u0947 User Define Function \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-function-\u0915-\u0915-\u092f-\u092b-\u092f\u0926-\u0939-\u0924-\u0939-benefit-of-mysql-function\">MySQL Function \u0915\u0947 \u0915\u094d\u092f\u093e \u092b\u093e\u092f\u0926\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 ? Benefit of MySQL Function ?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Easy to Understand :<\/strong> Function \u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0938\u0947 Program \u0938\u092e\u091d\u0928\u093e \u0906\u0938\u093e\u0928 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li><li><strong>Time Saving :<\/strong> \u092d\u0935\u093f\u0937\u094d\u092f \u092e\u0947 \u092f\u0926\u093f \u0939\u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Changes \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u094b \u0939\u092e \u0915\u0947\u0935\u0932 Function \u092e\u0947 Changes \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u0915\u0947\u0935\u0932 \u090f\u0915 \u0939\u0940 \u091c\u0917\u0939 Change \u0915\u0930\u0928\u0947 \u0938\u0947 \u0939\u092e\u0928\u0947 \u091c\u0939\u093e \u091c\u0939\u093e \u092d\u0940 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0938\u092d\u0940 \u091c\u0917\u0939 Change \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"steps-for-creating-mysql-function\">Steps For Creating MySQL Function <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>1. Click on Database <\/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> \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> <strong>Click On Routines :<\/strong> \u0905\u092c \u0906\u092a Routines \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/li><li><strong>4. Add Routine<\/strong> : \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=\"344\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?resize=640%2C344&#038;ssl=1\" alt=\"phpmyadmin Routines\" class=\"wp-image-2126\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?w=849&amp;ssl=1 849w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?resize=300%2C161&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?resize=768%2C412&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?resize=465%2C250&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/phpmyadmin-Routines.jpg?resize=695%2C373&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\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<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"362\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?resize=640%2C362&#038;ssl=1\" alt=\"Create MySQL Function (UDF)\" class=\"wp-image-2129\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?w=853&amp;ssl=1 853w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?resize=768%2C435&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?resize=465%2C263&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-add-Routine-Option.jpg?resize=695%2C394&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Routine Name :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u091c\u093f\u0938 \u0928\u093e\u092e \u0938\u0947 \u0939\u092e Function \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 : <\/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 : <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u094b Parameter \u0926\u0947\u0928\u093e \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 , \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u092c \u0939\u092e Function \u0915\u094b Call \u0915\u0930\u0947 \u0924\u092c \u0915\u0941\u091b Value \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Function \u0915\u094b Input \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 Input \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>Name :<\/strong> Parameter \u0915\u093e \u0928\u093e\u092e \u092f\u0939\u093e\u0901 \u092a\u0930 \u0932\u093f\u0916\u0947<\/li><\/ul><ul><li><strong>Type :<\/strong> Parameter \u0915\u093e Data Type \u092f\u0939\u093e\u0901 \u092a\u0930 \u0938\u0947 Select \u0915\u0930\u0947 \u0964<\/li><li><strong>Length :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 Width \u0932\u093f\u0916\u0947 \u0964<\/li><\/ul><\/li><li><strong>Return Type :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u091c\u093f\u0938 Type \u0915\u0940 Value Function Return \u0915\u0930\u0947\u0917\u093e \u0935\u0939 Datatype select \u0915\u0930\u0947 \u0964<\/li><li><strong>Return Length :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 Data \u0915\u0940 Width \u0932\u093f\u0916\u0947 \u0964<\/li><li><strong>Return Option : <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 Character Set \u0932\u093f\u0916\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u092f\u0926\u093f \u0906\u092a English \u092e\u0947\u0902 \u0939\u0940 Return \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u091c\u0948\u0938\u093e \u0939\u0948\u0902 \u0935\u0948\u0938\u093e \u0939\u0940 \u0930\u0939\u0928\u0947 \u0926\u0947 \u0914\u0930 \u092f\u0926\u093f \u0906\u092a Hindi \u092e\u0947\u0902 \u092f\u093e \u0915\u094b\u0908 Unicode \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b UTF-8 \u0906\u0926\u093f Select \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>Definition :<\/strong> \u092f\u0939 Function \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&#8230;.END \u0932\u0917\u093e\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \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=\"362\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?resize=640%2C362&#038;ssl=1\" alt=\"Create MySQL Function (UDF)\" class=\"wp-image-2137\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?w=853&amp;ssl=1 853w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?resize=300%2C170&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?resize=768%2C435&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?resize=465%2C263&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Edit-Routine.jpg?resize=695%2C394&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Is deterministic<\/strong> : \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> : \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 : <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 User Permission \u0926\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948 \u0964<\/li><li><strong>Security Type : <\/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> \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<ul><li><strong>NO SQL :<\/strong> \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<\/li><li><strong>MODIFIES SQL DATA:<\/strong> \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> \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> \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 Function \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 Function \u0915\u094b Save \u0915\u0930\u0947 \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932 <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-c-basic-n-advance\/\">Learn C &#8211; \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 <\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\">MySQL Aggregate Function in Hindi<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-sys-exec-example-with-trigger\/\">MySQL SYS_EXEC Example With Trigger<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">GET &amp; POST Method | Difference Between GET &amp; POST<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-validation-filter-var-preg_match\/\">PHP Validation | filter_var | preg_match<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-function-udf-example\">MySQL Function (UDF) Example<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0939\u092e \u092f\u0939\u093e\u0901 \u092a\u0930 \u090f\u0915 Example \u0932\u0947 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e\u0947\u0902 \u090f\u0915 Table mst_item \u0938\u0947 item \u0915\u0947 Name Transaction Table trn_item \u0915\u0947 \u0938\u093e\u0925 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0939\u092e \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Function \u092c\u0928\u093e \u0915\u0930 \u0909\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/ Master Table Structure \nCREATE TABLE IF NOT EXISTS `mst_item` (\n  `item_id` int(6) NOT NULL AUTO_INCREMENT,\n  `item_nm` varchar(40) NOT NULL,\n  `op_qty` decimal(9,2) NOT NULL DEFAULT 0.00,\n  `pur_qty` decimal(9,2) NOT NULL DEFAULT 0.00,\n  `sal_qty` decimal(9,2) NOT NULL DEFAULT 0.00,\n  `cl_qty` decimal(9,2) NOT NULL DEFAULT 0.00,\n  PRIMARY KEY (`item_id`)\n);\n\n\/\/ Function \nDELIMITER $$\nCREATE DEFINER=`a1679ym8_b683had`@`localhost` FUNCTION `get_item_name`(`p_id` INT(9)) RETURNS varchar(40) CHARSET latin1\n    NO SQL\nBEGIN\n\n    declare ls_nm varchar(40);\n\n    \n    select item_nm into ls_nm \n    from mst_item \n    where item_id = p_id;\n\n\n    return (ls_nm);\n \n\nEND$$\nDELIMITER ;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mysql-function-udf-output\">MySQL Function (UDF) Output<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>1. \u092f\u0926\u093f \u0906\u092a Direct Execute \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902  \u0924\u094b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0932\u093f\u0916\u0947 \u0964<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT get_item_name(2);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 2 \u0928\u0902\u092c\u0930 \u092a\u0930 \u091c\u093f\u0938 \u092d\u0940 item \u0915\u093e \u0928\u093e\u092e \u0939\u094b\u0917\u093e \u0935\u0939 \u0906\u092a\u0915\u094b \u0930\u093f\u091c\u0932\u094d\u091f \u092e\u0947\u0902 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u091c\u0948\u0938\u0947 \u0915\u0940 Computer.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>2. \u092f\u0926\u093f \u0906\u092a Select SQL \u092e\u0947\u0902 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0932\u093f\u0916\u0947 \u0964<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT *, get_item_name(item_id) as item_nm \nFROM `trn_item`;\n<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 Parameter \u092e\u0947\u0902 trn_item Table \u0915\u0940 item_id \u0915\u094b Parameter \u0915\u0940 \u091c\u0917\u0939 Pass \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u092c \u0906\u092a \u0907\u0938\u0915\u093e \u0930\u093f\u091c\u0932\u094d\u091f \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0924\u094b \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\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=\"103\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?resize=640%2C103&#038;ssl=1\" alt=\"\" class=\"wp-image-2154\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?w=914&amp;ssl=1 914w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?resize=300%2C48&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?resize=768%2C124&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?resize=465%2C75&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/MySQL-Function-Result.jpg?resize=695%2C112&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">SQL Logic App Download \u0915\u0930\u0947 \u0914\u0930 \u0938\u0940\u0916\u0947 MySQL \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 <\/a><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 Article \u0906\u092a\u0915\u094b \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0915\u0943\u092a\u092f\u093e Comment \u0915\u0930\u0915\u0947 \u092c\u0924\u093e\u092f\u0947 \u0964 \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<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0907\u0938 Article \u092e\u0947 \u0939\u092e MySQL Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0947\u0902\u0917\u0947 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947 \u0915\u0948\u0938\u0947 \u0939\u092e UDF (User Define Function) \u0932\u093f\u0916\u0928\u093e \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0964 MySQL Function \u0915\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 ? \u091c\u092c \u092d\u0940 \u0939\u092e \u0915\u094b\u0908 \u092d\u0940 \u0915\u093e\u0930\u094d\u092f \u092f\u093e SQL Query \u0915\u094b \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u092c\u093e\u0930 \u090a\u092a\u092f\u094b\u0917 \u092e\u0947 \u0932\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e Query \u0915\u094b Function \u092e\u0947 \u0932\u093f\u0916\u0947 \u0926\u0947\u0924\u0947 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2162,"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-2122","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-Function.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2122","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=2122"}],"version-history":[{"count":56,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2122\/revisions"}],"predecessor-version":[{"id":7780,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2122\/revisions\/7780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/2162"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=2122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=2122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}