{"id":2215,"date":"2021-08-10T09:00:00","date_gmt":"2021-08-10T03:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=2215"},"modified":"2021-08-07T16:53:32","modified_gmt":"2021-08-07T11:23:32","slug":"mysql-view","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-view\/","title":{"rendered":"MySQL View"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\">View \u090f\u0915 Database object \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 Select Query \u0915\u094b Store \u0915\u0930 \u0930\u0916\u0924\u093e \u0939\u0948\u0902,  \u0907\u0938\u092e\u0947\u0902 \u0939\u092e \u0915\u0947\u0935\u0932 Select Query \u0939\u0940 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u0915\u094b\u0908 \u092d\u0940 View Save \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a View \u0915\u094b Table \u092e\u093e\u0928\u0915\u0930 \u0909\u0938 \u092a\u0930 \u092d\u0940 SELECT Query Run \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL View Advantage<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>View \u092c\u0928\u093e\u0928\u093e \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u091c\u092c \u0939\u092e \u092c\u093e\u0930 \u092c\u093e\u0930 \u090f\u0915 \u091c\u0948\u0938\u0940 Select Query Execute \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0939\u092e View \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>View \u092e\u0947\u0902 \u0939\u092e Aggregate Distinct Group by \u0906\u0926\u093f \u0938\u092d\u0940 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/li><li>View \u092e\u0947\u0902 \u0939\u092e Sub Query \u092d\u0940 \u0932\u093f\u0916\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/li><li>View \u092e\u0947\u0902 \u0939\u092e Join \u0932\u0917\u093e \u0915\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Table \u0915\u093e \u0921\u093e\u091f\u093e \u092d\u0940 Show \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>View \u0939\u092e\u093e\u0930\u0940 \u092e\u0948\u0902 \u091f\u0947\u092c\u0932 \u0915\u0947 \u0921\u093e\u091f\u093e \u0915\u094b Secure \u092d\u0940 \u0915\u0930\u0928\u0947 \u0915\u093e \u0911\u092a\u094d\u0936\u0928 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 .<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"> MySQL View Disadvantage <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c Table \u092e\u0947\u0902 \u091c\u094d\u092f\u093e\u0926\u093e Data \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u094b View \u092d\u0940 Slow \u0939\u094b \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0939 \u0921\u093e\u091f\u093e Table \u092a\u0930 SQL \u091a\u0932\u093e \u0915\u0930 \u0939\u0940 \u0932\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>View \u092a\u0930 \u0939\u092e <strong>Trigger<\/strong> \u0928\u0939\u0940\u0902 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0964<\/li><li>View \u092a\u0930 \u0939\u092e <strong>Index<\/strong> \u092d\u0940 \u0928\u0939\u0940\u0902 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL View Example Using Command <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0906\u092a \u090f\u0915 Table \u092c\u0928\u093e \u0932\u0940\u091c\u093f\u092f\u0947 \u091c\u093f\u0938 \u092a\u0930 \u0939\u092e\u0947\u0902 View \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE `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) ;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Table \u092e\u0947\u0902 \u0915\u0941\u091b Dummy \u0921\u093e\u091f\u093e Insert \u0915\u0930 \u0932\u0940\u091c\u093f\u092f\u0947 \u0924\u093e\u0915\u093f \u0939\u092e \u0920\u0940\u0915 \u0938\u0947 Example \u0915\u094b \u0938\u092e\u091d \u0938\u0915\u0947 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO `mst_item` (`item_id`, `item_nm`, `op_qty`, `pur_qty`, `sal_qty`, `cl_qty`) VALUES\n(1, 'Speaker', '8.00', '5.00', '0.00', '13.00'),\n(2, 'Item ', '5.00', '10.00', '2.00', '13.00'),\n(3, 'Computer', '0.00', '5.00', '3.00', '2.00'),\n(4, 'Monitor', '0.00', '10.00', '4.00', '6.00'),\n(5, 'Key Board', '0.00', '20.00', '0.00', '20.00');<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u092a \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u092d\u0940 View \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092e\u0941\u091d\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 mst_item \u091f\u0947\u092c\u0932 \u0938\u0947 \u0935\u0939 \u0938\u092d\u0940 \u0921\u093e\u091f\u093e \u091a\u093e\u0939\u093f\u090f \u0925\u0947 \u091c\u093f\u0928\u0915\u0940 Closing Qty 10 \u0914\u0930 10 \u0938\u0947 \u0915\u092e \u0939\u094b , \u0907\u0938\u0932\u093f\u090f \u092e\u0947\u0928\u0947 \u092f\u0939\u093e\u0901 SQL \u0932\u093f\u0916\u0940 \u0939\u0948 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL CREATE VIEW<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE VIEW ViewMinStock\nAS\nselect item_id, item_nm, op_qty, cl_qty \nfrom mst_item\nwhere cl_qty &lt;= 10;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Successfully Saved \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 SQL Execute \u0915\u0930 \u092d\u0940 View \u0915\u093e \u0921\u093e\u091f\u093e \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u094b \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">select * from ViewMinStock <\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a Column \u0915\u0947 \u0928\u093e\u092e \u092d\u0940 \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u092f\u0926\u093f Where Clause \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0947 \u0924\u094b \u0935\u0939 \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u094b, Group By \u0906\u0926\u093f \u0938\u092d\u0940 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL ALTER VIEW <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a View \u092e\u0947\u0902 \u0915\u0941\u091b Change \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 SQL \u092e\u0947\u0902 Change \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">ALTER VIEW ViewMinStock\nAS\nselect item_id, item_nm, op_qty, cl_qty \nfrom mst_item\nwhere cl_qty &lt;= 5;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL DROP VIEW<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a View \u0915\u094b Drop \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Delete \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DROP VIEW ViewMinStock;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL View Using Graphics<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>\u091c\u093f\u0938 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0906\u092a\u0915\u094b \u0935\u094d\u092f\u0942 \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0909\u0938 \u091f\u0947\u092c\u0932 \u0915\u094b \u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0947 <\/li><li>\u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0928\u093f\u091a\u0947 \u0906\u092a\u0915\u094b Create View\u0911\u092a\u094d\u0936\u0928 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u0909\u0938 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 .<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"304\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?resize=640%2C304&#038;ssl=1\" alt=\"\" class=\"wp-image-2221\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?w=854&amp;ssl=1 854w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?resize=300%2C142&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?resize=768%2C364&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?resize=465%2C221&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-1.jpg?resize=695%2C330&amp;ssl=1 695w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Create View \u0911\u092a\u094d\u0936\u0928 \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0926\u093f\u0916\u093e \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=\"606\" height=\"461\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Mysql-View-GUI.jpg?resize=606%2C461&#038;ssl=1\" alt=\"MySQL View\" class=\"wp-image-2219\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Mysql-View-GUI.jpg?w=606&amp;ssl=1 606w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Mysql-View-GUI.jpg?resize=300%2C228&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Mysql-View-GUI.jpg?resize=465%2C354&amp;ssl=1 465w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u0907\u092f\u0947 \u0906\u092a\u0915\u094b \u090f\u0915 \u090f\u0915 \u0915\u0930 \u0938\u092d\u0940 \u0911\u092a\u094d\u0936\u0928 \u092a\u0939\u0932\u0947 \u0938\u092e\u091d\u093e \u0926\u0947\u0924\u093e \u0939\u0941 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>OR REPLACE : <\/strong>\u092f\u0926\u093f \u0906\u092a \u092a\u0939\u0932\u0947 \u0938\u0947 \u092c\u0928\u0947 Trigger \u092e\u0947\u0902 Change \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0924\u094b \u092f\u0939\u093e\u0901 \u092a\u0930 \u091f\u093f\u0915 \u0915\u0930\u0947 , \u092f\u0926\u093f \u0906\u092a \u091c\u094b \u0928\u093e\u092e View Name \u092e\u0947\u0902 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0909\u0938 \u0928\u093e\u092e \u0938\u0947 \u092a\u0939\u0932\u0947 \u0938\u0947 \u0939\u0941\u0906 \u0924\u094b \u0935\u0939 Replace \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>ALGORITHM :<\/strong> \u092f\u0926\u093f \u0906\u092a Command \u0938\u0947 \u092c\u0928\u093e\u0924\u0947 \u0938\u092e\u092f Algorithm \u0928\u0939\u0940\u0902 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Default me UNDEFINED ALGORITHM \u0939\u0940 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0924\u093e \u0939\u0948\u0902 \u0964<ul><li><strong>UNDEFINED : <\/strong>\u092f\u0939 View \u092e\u0947\u0902 \u0932\u093f\u0916\u0947 SQL \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 ALGORITHM \u0938\u0947\u091f \u0915\u0930 \u0932\u0947\u0917\u093e \u092f\u0926\u093f SQL \u092e\u0947\u0902 DISTINCT,GROUP BY AGGREGATE FUNCTION \u0906\u0926\u093f \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0902\u0917\u0947 \u0924\u094b View Updatable \u0928\u0939\u0940\u0902 \u0939\u094b\u0917\u093e \u0924\u092c \u0935\u0939 TEMPTABLE ALOGRITHM \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0917\u093e \u0914\u0930 Otherwise \u0935\u0939 MERGE ALGORITHM \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0917\u093e \u0964<\/li><li><strong>MERGE: <\/strong>\u092f\u0926\u093f \u0939\u092e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 View \u0915\u0947 data \u0915\u094b \u0939\u092e Insert\/Update\/Delete \u0915\u0930 \u0938\u0915\u0947 \u0924\u094b \u0939\u092e\u0947\u0902 Algorithm \u0915\u094b MERGE \u0938\u0947\u091f \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u093f\u090f, \u0932\u0947\u0915\u093f\u0928 \u092f\u0939 \u091c\u092c \u0939\u0940 \u0938\u0947\u091f \u0939\u094b\u0917\u0940 \u0924\u092c \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Aggregate \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u094b \u0914\u0930 DISTINCT \u0906\u0926\u093f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u0939\u094b \u0964<\/li><li><strong>TEMPTABLE : <\/strong>\u092f\u0926\u093f \u0939\u092e TEMPTABLE Algorithm \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Direct Data \u0928 \u0926\u093f\u0916\u0924\u0947 \u0939\u0941\u090f \u0939\u092e\u0947\u0902 TEMPTABLE \u0938\u0947 \u0921\u093e\u091f\u093e \u0926\u093f\u0916\u0924\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0939\u092e \u0909\u0938\u0947 Update \u0928 \u0915\u0930 \u0938\u0915\u0947 \u0964<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Definer: <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0909\u0938 User \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e View \u092c\u0928\u093e\u092f\u093e \u0917\u092f\u093e \u0909\u0938\u0915\u0940 User ID \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0924\u0940 \u0939\u0948 \u0964<ul><li><strong>DEFINER : <\/strong>\u091c\u092c \u0915\u094b\u0908 \u092d\u0940 \u0907\u0938 View \u092a\u0930 \u0915\u094b\u0908 Operation \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0924\u094b \u092c\u0928\u093e\u0928\u0947 \u0935\u093e\u0932\u0947 \u0915\u094b \u091c\u094b Privilege \u092e\u093f\u0932\u0947 \u0909\u0938\u0940 \u092e\u093e\u0928\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>INVOKER : <\/strong>\u091c\u094b View \u0915\u094b Execute \u0915\u0930 \u0930\u0939\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u094b \u091c\u094b Privilege \u0939\u0948\u0902 \u0909\u0928\u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u091a\u0932\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>View Name : \u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u094b View \u0915\u093e \u0928\u093e\u092e \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Column Names :<\/strong> \u092f\u0939\u093e\u0901 \u092a\u0930 \u0916\u093e\u0932\u0940 \u0939\u0940 \u0930\u0916\u0947 \u091c\u094b \u092d\u0940 \u0906\u092a SQL \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u0940 \u092f\u0939 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0932\u0947\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>As :<\/strong> \u091c\u093f\u0938 \u0915\u093e\u0930\u094d\u092f \u0915\u0947 \u0932\u093f\u090f \u0906\u092a View \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0964 \u0935\u0939 SQL \u0906\u092a\u0915\u094b \u092f\u0939\u093e\u0901 \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>WITH CHECK OPTION :<\/strong> \u092f\u0926\u093f \u0906\u092a View \u092a\u0930 Insert\/ Update \u0915\u0947 Case \u092e\u0947\u0902 \u091c\u094b Where Clause \u092e\u0947\u0902 Condition \u0939\u0948\u0902 \u0935\u0939 \u091c\u094b Data Insert\/Update \u0915\u093f\u092f\u093e \u091c\u093e \u0930\u0939\u093e \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 True \u0939\u094b \u0924\u092c \u0939\u0940 \u0921\u093e\u091f\u093e \u0915\u094b Insert\/Update \u0915\u0930\u0928\u0947 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 2 option \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 \u0938\u092c Security Check \u0939\u0948\u0902 \u0964<ul><li><strong>BLANK :<\/strong> \u092f\u0926\u093f Blank select \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0924\u094b \u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e \u0915\u094b\u0908 \u091a\u0947\u0915 \u0928\u0939\u0940\u0902 \u0932\u0917\u0924\u093e \u0939\u0948\u0902 \u0906\u092a \u0915\u0941\u091b \u092d\u0940 Insert\/Update \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>CASCADED :<\/strong> \u092f\u0926\u093f \u0906\u092a\u0928\u0947 \u0915\u094b\u0908 x view \u0932\u093f\u0916\u093e \u0914\u0930 \u0909\u0938 x view \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0909\u0938 \u092a\u0930 y View \u0932\u093f\u0916\u093e, \u0905\u092c \u0906\u092a\u0928\u0947 \u0915\u094b\u0908 \u0921\u093e\u091f\u093e Insert \u0915\u093f\u092f\u093e \u091c\u094b y \u0915\u0947 Where Clause \u0915\u094b \u0924\u094b Satisfy \u0915\u0930 \u0930\u0939\u093e \u0939\u0948\u0902 \u092a\u0930\u0928\u094d\u0924\u0941 x \u0915\u0947 Where Clause \u0915\u094b Satisfy \u0928\u0939\u0940\u0902 \u0915\u0930 \u0930\u0939\u093e \u0939\u094b , \u0924\u094b \u092f\u0939 CASCADED Option \u0921\u093e\u091f\u093e Insert\/Update \u0928\u0939\u0940\u0902 \u0915\u0930\u0928\u0947 \u0926\u0947\u0917\u093e , \u092f\u093e\u0928\u093f \u0915\u0940 \u090f\u0915 Table \u092a\u0930 \u090f\u0915 Sequence \u092a\u0930 \u0915\u093f\u0924\u0928\u0940 \u0939\u0940 View \u0932\u093f\u0916\u0947 \u0939\u094b \u091c\u092c \u0938\u092d\u0940 \u0915\u0947 Where satisfy \u0939\u094b\u0902\u0917\u0947 \u0924\u092c \u0939\u0940 \u092f\u0939 \u0921\u093e\u091f\u093e \u0915\u094b Insert\/Update \u0915\u0930\u0928\u0947 \u0926\u0947\u0917\u093e \u0964<\/li><li><strong>LOCAL :<\/strong> \u092f\u0939 \u0915\u0947\u0935\u0932 Current \u0935\u093e\u0932\u0947 View \u0915\u0940 \u0939\u0940 Where Clause \u0915\u094b \u091a\u0947\u0915 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u092f\u0926\u093f Current View \u0915\u0940 Condition Satisfy \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 \u0921\u093e\u091f\u093e \u0915\u094b Insert \u0915\u0930\u0928\u0947 \u0926\u0947\u0917\u093e \u0964<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 GO Button \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Side \u0935\u093e\u0932\u0947 \u092c\u093e\u0930 \u0915\u094b Refresh \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0905\u092c \u092f\u0939\u093e\u0901 \u092a\u0930 View \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a View \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0947\u0902\u0917\u0947 \u0914\u0930 \u0909\u0938 View \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930 \u0906\u092a \u0909\u0938\u0915\u093e \u0921\u093e\u091f\u093e \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \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=\"303\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?resize=640%2C303&#038;ssl=1\" alt=\"\" class=\"wp-image-2278\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?w=854&amp;ssl=1 854w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?resize=300%2C142&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?resize=768%2C363&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?resize=465%2C220&amp;ssl=1 465w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Pasted-2.jpg?resize=695%2C329&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<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL View Advance Option<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 Article \u092e\u0947\u0902 \u0939\u092e\u0928\u0947 View \u0915\u0947 Basic \u0911\u092a\u094d\u0936\u0928 \u0926\u0947\u0916\u0947 \u092f\u0926\u093f \u0906\u092a Algorithm \u0914\u0930 With Check option Example \u0938\u0947 \u0938\u092e\u091d\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Video \u0926\u0947\u0916\u0947 \u0964<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL View Advantage View \u092c\u0928\u093e\u0928\u093e \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u091c\u092c \u0939\u092e \u092c\u093e\u0930 \u092c\u093e\u0930 \u090f\u0915 \u091c\u0948\u0938\u0940 Select Query Execute \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0939\u092e View \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 View \u092e\u0947\u0902 \u0939\u092e Aggregate Distinct Group by \u0906\u0926\u093f \u0938\u092d\u0940 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 View \u092e\u0947\u0902 \u0939\u092e Sub Query \u092d\u0940 \u0932\u093f\u0916\u0947 \u0938\u0915\u0924\u0947 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2302,"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-2215","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-View-Hindi.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2215","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=2215"}],"version-history":[{"count":84,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2215\/revisions"}],"predecessor-version":[{"id":2304,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2215\/revisions\/2304"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/2302"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=2215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=2215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=2215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}