{"id":8745,"date":"2022-09-05T00:49:44","date_gmt":"2022-09-04T19:19:44","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=8745"},"modified":"2022-11-13T17:16:25","modified_gmt":"2022-11-13T11:46:25","slug":"mysql-overview-in-hindi","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-overview-in-hindi\/","title":{"rendered":"MySQL Overview in Hindi"},"content":{"rendered":"\n<p>\u092f\u0926\u093f \u0906\u092a \u092f\u0939 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 MySQL Overview Read \u0915\u0930\u0928\u0947 \u0906\u090f \u0939\u0948 \u0907\u0938\u0915\u0947 \u0926\u094b \u0915\u093e\u0930\u0923 \u0939\u094b \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u092a\u0939\u0932\u093e \u0915\u0940 \u0906\u092a Programming \u0915\u0940 \u0926\u0941\u0928\u093f\u092f\u093e \u092e\u0947 \u092a\u0939\u0932\u0947 \u0938\u0947 \u0939\u0940 \u0939\u0948\u0902 \u0914\u0930 \u0905\u0928\u094d\u092f Programming Language \u0915\u0947 \u0938\u093e\u0925 \u0906\u092a SQL \u092d\u0940 \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0926\u0942\u0938\u0930\u093e \u0915\u093e\u0930\u0923 \u092f\u0939 \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a\u0928\u0947 \u092a\u094d\u0930\u094b\u0917\u094d\u0930\u093e\u092e\u093f\u0902\u0917 \u0938\u0940\u0916\u0928\u093e \u0936\u0941\u0930\u0942 \u0939\u0940 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0914\u0930 \u0906\u092a SQL \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What is SQL and MySQL? <\/h3>\n\n\n\n<p>MySQL \u0939\u092e\u093e\u0930\u093e \u0918\u0930 \u0939\u0948\u0902 \u0914\u0930 SQL \u0939\u092e\u093e\u0930\u0947 \u0918\u0930 \u092e\u0947 \u0915\u094c\u0928 \u0938\u0940 \u0935\u0938\u094d\u0924\u0941 \u0915\u0939\u093e \u0930\u0916\u0928\u093e \u0939\u0948\u0902 ?, \u0909\u0938\u092e\u0947 \u0915\u094d\u092f\u093e \u092c\u0926\u0932\u093e\u0935 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 ?, \u0909\u0938\u0947 \u0915\u0939\u0940\u0902 \u0914\u0930 \u0936\u093f\u092b\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u0948\u0902 ?, \u0909\u0938\u0947 \u0918\u0930 \u0915\u0947 \u092c\u093e\u0939\u0930 \u0939\u0940 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 ? \u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 \u0906\u0926\u0947\u0936 \u0926\u0947\u0928\u0947 \u0915\u0940 \u092d\u093e\u0937\u093e \u0915\u094b \u0939\u092e SQL \u0915\u0939\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u093e\u0928\u093f \u0915\u0940 MySQL \u090f\u0915 Database \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938 database \u092e\u0947 \u0905\u0932\u0917 \u0905\u0932\u0917 \u091f\u0947\u092c\u0932 \u092e\u0947 \u0939\u092e Data \u0915\u094b Store \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u091c\u0948\u0938\u0947 \u0939\u092e\u093e\u0930\u0947 \u0918\u0930 \u092e\u0947 \u0905\u0932\u0917 \u0905\u0932\u0917 Room \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0935\u0948\u0938\u0947 \u0939\u0940 Database \u092e\u0947 \u0939\u092e Data \u0915\u094b Table \u092e\u0947 store \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 business application \u092c\u0928\u093e\u090f \u0914\u0930 \u0906\u092a \u092f\u0926\u093f data store \u0915\u0930\u0928\u0947 \u0915\u0940 need \u0939\u094b \u0914\u0930 \u0909\u0938\u0947 \u092d\u0940 \u0915\u093f\u0938\u0940 \u0924\u0930\u0939 \u0915\u0947 calculation \u0915\u0930 \u0932\u093e\u0928\u093e \u0939\u094b \u0924\u092c \u0906\u092a\u0915\u094b \u0915\u093f\u0938\u0940 \u092d\u0940 Databse \u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0932\u0947\u0928\u093e \u0939\u094b\u0917\u0940, \u091c\u0948\u0938\u0947 \u091c\u0948\u0938\u0947 \u0906\u092a\u0915\u0940 Requirment \u092c\u095d\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0905\u0928\u0941\u0930\u0942\u092a \u0939\u0940 \u0906\u092a\u0915\u094b Databse \u0938\u093f\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0906\u0907\u090f \u092e\u0947 \u0906\u092a\u0915\u094b \u0915\u0941\u091b Database \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0924\u093e \u0939\u0941 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">List of Database <\/h3>\n\n\n\n<p>Excel , Ms Access, Sybase Adaptive Server, MySQL, SQL Server, Oracle, PostgreSQL  , SQLite, Maria DB, IBM DB2 \u0906\u0926\u093f \u0964 \u0910\u0938\u0947 \u0914\u0930 \u092d\u0940 database \u0939\u0948\u0902 \u0939\u092e\u0928\u0947 \u0907\u0938\u092e\u0947 \u0915\u0941\u091b \u0915\u0947 \u0928\u093e\u092e \u0932\u093f\u0916\u0947 \u0939\u0948\u0902 \u0964     <\/p>\n\n\n\n<p>\u0906\u092a \u0915\u094b\u0908 \u092d\u0940 Database \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947, \u0906\u092a\u0915\u094b Data \u0915\u094b Store \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u091c\u094b Language \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0935\u0939\u0940 SQL \u0939\u0948\u0902 , \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f \u0906\u092a\u0928\u0947 SQL \u0938\u093f\u0916 \u0932\u0940 \u0924\u094b \u0906\u092a \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 databse \u092e\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 database \u0915\u0940 \u0905\u092a\u0928\u0940 \u092c\u0939\u0941\u0924 \u0938\u0940 \u0935\u093f\u0936\u0947\u0937\u0924\u093e\u090f \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0914\u0930 \u0915\u0941\u091b limitation \u092d\u0940 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 \u0939\u092e\u0947 \u0905\u092a\u0928\u0947 project \u0915\u0940 \u091c\u0930\u0942\u0930\u0924 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Dabase \u0915\u093e \u091a\u092f\u0928 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>\u0907\u0938 Blog \u092e\u0947 \u0906\u092a\u0915\u094b \u092e\u0947 MySQL Database \u0915\u094b Example \u0915\u0947 \u0930\u0942\u092a \u092e\u0947 \u0932\u0947\u0915\u0930 \u0906\u092a\u0915\u094b SQL \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u092c\u0924\u093e\u090a\u0901\u0917\u093e \u0964 \u092f\u0926\u093f \u0906\u092a SQL \u0938\u093f\u0916 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0915\u0941\u091b \u0915\u0940 Command \u0910\u0938\u0940 \u0939\u094b \u0938\u0915\u0924\u0940 \u0939\u0948\u0902 \u091c\u094b \u0906\u092a\u0915\u094b \u0905\u0928\u094d\u092f database \u092e\u0947 support \u0928 \u0915\u0930\u0947 \u0924\u094b \u0906\u092a \u0909\u0938\u0915\u093e alternet \u0938\u0930\u094d\u091a \u0915\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u093e\u0928\u093f \u0906\u092a SQL \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0915\u093f\u0938\u0940 \u092d\u0940 Database \u092a\u0930 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u091a\u0932\u093f\u090f \u0936\u0941\u0930\u0942 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>MySQL \u0915\u094b \u0939\u092e part \u092e\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Structure of MySQL :<\/strong> \u0907\u0938\u092e\u0947 \u0939\u092e Structure \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0947\u0902\u0917\u0947 <\/li>\n\n\n\n<li><strong>Command :<\/strong> \u0907\u0938 Part \u092e\u0947 \u0939\u092e \u0938\u092d\u0940 Command \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0947\u0902\u0917\u0947 \u0964 <\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<iframe src=\"https:\/\/selfimagination.in\/webapps\/Tutorial\/MySQL\/index.php?f=blog\" width=\"100%\" height=\"600\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\"><\/iframe>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/dwKr33RG3UA\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Overview in Hindi | MySQL Terminology<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Structure of MySQL <\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"#c-11\">1.1 Database<\/a> :<\/strong> \u0907\u0938 \u0911\u092a\u094d\u0936\u0928 \u092e\u0947 \u0906\u092a \u0915\u093f\u0924\u0928\u0947 \u0939\u0940 Database \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong><a href=\"#c-12\">1.2 User<\/a> :<\/strong> \u0907\u0938 Option \u0938\u0947 \u0906\u092a User \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 \u092f\u0942\u091c\u0930 \u0915\u094b permission \u092d\u0940 \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-11\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-database-phpmyadmin\/\">1.1 MySQL Databases<\/a><\/h2>\n\n\n\n<p>Database \u092c\u0939\u0941\u0924 \u0938\u0940 Table, Function Procedure \u0915\u093e \u0938\u092e\u0942\u0939 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 Table \u092c\u0928\u093e \u0915\u0930 Data \u0915\u094b Store \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948 \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e Database Data \u0915\u094b handle \u0915\u0930\u0928\u0947 \u0915\u0947  \u0932\u093f\u090f \u0939\u092e \u0915\u094d\u092f\u093e \u0915\u094d\u092f\u093e \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"#c-111\">1.1.1 Table<\/a> :<\/strong> Datastore \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Table \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902  \u0964 Table \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0939\u092e \u0915\u0939\u0940 \u0914\u0930 Data \u0915\u094b Store \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong><a href=\"#c-112\">1.1.2 View<\/a> :<\/strong> \u092f\u0939 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 Virtual Table \u0939\u0948\u0902 , \u0907\u0938\u092e\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 \u090f\u0915 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Table \u0915\u094b \u0932\u093f\u0902\u0915 \u0915\u0930 Data \u0926\u093f\u0916\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0938\u093e\u0925 \u0939\u0940 \u092e\u0947 \u0939\u092e selected columns \u0914\u0930 Rows \u0915\u094b \u092d\u0940 Filter \u0915\u0930 \u0926\u093f\u0916\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong><a href=\"#c-113\">1.1.3 Function<\/a> :<\/strong> \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Data \u092a\u0930 \u0915\u094b\u0908 Operation \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u0939\u092e \u0915\u093f\u0938\u0940 \u092c\u095c\u0947 Code \u0915\u094b \u090f\u0915 Saparate Block \u092e\u0947 \u0932\u093f\u0916\u0928\u093e \u091a\u093e\u0939\u0947 \u0924\u092c \u0939\u092e Function \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 , \u0914\u0930 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092c\u0928\u0947 \u0939\u0941\u0935\u0947 Function \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li><strong><a href=\"#c-114\">1.1.4 Procedure<\/a> : <\/strong>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u094b\u0908 Specific Task \u0915\u0947 \u0932\u093f\u090f \u0915\u094b\u0908 Code \u0932\u093f\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Procedure \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0909\u092a\u092f\u094b\u0917 \u0939\u094b\u0928\u0947 \u092a\u0930 \u0909\u0938 Block \u092f\u093e\u0928\u093f \u0915\u0940 Procedure \u0915\u094b call \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong><a href=\"#c-115\">1.1.5 Trigger<\/a> : <\/strong>Trigger \u0915\u093f\u0938\u0940 \u092d\u0940 Table \u092a\u0930 Insert \/ Update \/ Delete operation \u0939\u094b\u0928\u0947 \u092a\u0930 Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 \u091c\u093f\u0938 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Trigger \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 Time \u0914\u0930 Event \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Trigger Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><a href=\"#c-116\"><strong>1.1.6 Index<\/strong><\/a> : \u092f\u0939 \u090f\u0915 Technique \u0939\u0948\u0902 \u091c\u093f\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e \u091c\u093f\u0938 Record \u0915\u094b Access \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u0915\u092e \u0938\u0947 \u0915\u092e Step \u092e\u0947\u0902 \u092a\u0939\u0941\u0901\u091a \u0938\u0915\u0947\u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Record Search \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u092c\u0939\u0941\u0924 \u091c\u0932\u094d\u0926\u0940 \u0939\u092e\u0947\u0902 \u092e\u093f\u0932 \u0938\u0915\u0947 \u0964<\/li>\n\n\n\n<li><a href=\"#c-117\"><strong>1.1.7 Event<\/strong><\/a> : \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 MySQL \u092e\u0947 \u0915\u093f\u0938\u0940 Task \u0915\u094b Schedule \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u0915\u0939\u0947 \u0915\u0940 \u0915\u093f\u0938\u0940 Specific Date \u0914\u0930 Time \u092a\u0930 \u0915\u094b\u0908 Task Execute \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e MySQL Event \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-12\">1.2 MySQL User <\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0907\u0938 Option \u0938\u0947 \u0906\u092a MySQL \u092e\u0947 User Account \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u091c\u094b \u092d\u0940 User \u0906\u092a\u0928\u0947 \u092c\u0928\u093e\u090f \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0947 Permission \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u0948\u0938\u0947 \u0915\u0940 \u0935\u0939 \u0915\u094b\u0908 Table \u092c\u0928\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0915\u094d\u092f\u093e \u092f\u093e Data Enter \u0915\u0930 \u0938\u0915\u0924 \u0939\u0948\u0902 , \u092f\u093e \u092a\u0939\u0932\u0947 \u0938\u0947 Enter \u0915\u093f\u090f \u0939\u0941\u0935\u0947 Data \u092e\u0947 Changes \u0915\u0930 \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0915\u094d\u092f\u093e \u0906\u0926\u093f \u0964 <\/li>\n\n\n\n<li>\u0938\u093e\u0925 \u092e\u0947 \u092f\u0926\u093f \u0906\u092a \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u092c\u0928\u093e\u090f \u0917\u090f User \u0915\u094b \u0938\u092d\u0940 Database \u0928 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e Permit \u0915\u093f\u090f \u0917\u090f Database \u0939\u0940 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0924\u094b \u092d\u0940 \u0906\u092a \u092f\u0939\u093e\u0901 \u0938\u0947 \u0938\u0947\u091f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0964  <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/Rp0-yjSVx68\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL User Management | CREATE \/ ALTER \/ DROP \/ GRANT \/ REVOKE<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-111\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">1.1.1 Table<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Table \u092e\u0947 \u0939\u0940 Data Store \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>Data \u0915\u094b Row \u0914\u0930 columns \u0915\u0947 form \u092e\u0947 Save \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>Table Column \u092c\u0928\u093e\u0924\u0947 \u0938\u092e\u092f \u0939\u092e\u0947 \u0909\u0938 Column \u0915\u093e Data Type Set \u0915\u0930\u0928\u093e \u0939\u094b\u0924 \u0939\u0948\u0902 \u0915\u0940 \u0907\u0938\u092e\u0947 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0915\u093e \u0921\u093e\u091f\u093e Store \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e \u0964 \u0935\u0948\u0938\u0947 \u0924\u094b \u092c\u0939\u0941\u0924 \u0924\u0930\u0939 \u0915\u0947 Data Type MySQL \u0938\u092a\u094b\u0930\u094d\u091f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 \u092e\u0941\u0916\u094d\u092f \u0930\u0942\u092a \u0938\u0947 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947 \u0906\u0928\u0947 \u0935\u093e\u0932\u0947 Data Type \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0939\u0948\u0902 \u0964\n<ul class=\"wp-block-list\">\n<li>INT<\/li>\n\n\n\n<li>CHAR<\/li>\n\n\n\n<li>VARCHAR<\/li>\n\n\n\n<li>DATE<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/CadqqXZVsoI\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Table (Collation, Attributes, Null, Default, Auto_Increment, Virtuality )<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\"><strong>Read More&#8230;<\/strong><\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-112\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-view\/\">1.1.2 View<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>View \u090f\u0915 Virtual Table \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0907\u0938\u092e\u0947 Data Store \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u093e \u0939\u0948 , \u0932\u0947\u0915\u093f\u0928 \u0939\u092e \u091c\u092c \u092d\u0940 \u0907\u0938\u0915\u093e Data \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 \u092f\u0939 \u0909\u0938\u0940 \u0938\u092e\u092f Execute \u0939\u094b \u0915\u0930 table \u0938\u0947 Data \u0932\u093e \u0915\u0930 \u0926\u093f\u0916\u093e \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>View \u0939\u092e \u090f\u0915 \u0939\u0940 Table \u092e\u0947 \u0938\u0947 Selected Column \u0915\u0947 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/li>\n\n\n\n<li>View \u0939\u092e \u090f\u0915 \u0939\u0940 Table \u0915\u0940 Rows \u0915\u094b Filter \u0915\u0930 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902  \u0964 <\/li>\n\n\n\n<li>View \u0939\u092e \u090f\u0915 \u0938\u093e\u0925 Column Selection \u0914\u0930 Rows Filter \u0915\u0930 \u092d\u0940 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>View \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Table \u0915\u094b Join \u0915\u0930 \u092d\u0940 \u0939\u092e \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/Y1Y4T23cMGY\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL View | ALGORITHM : UNDEFINED\/MERGE\/TEMPTABLE, WITH CHECK OPTION<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-view\/\"><strong>Read More&#8230;<\/strong><\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-113\">1.1.3 Function <\/h2>\n\n\n\n<p>Function \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Repitative task \u0915\u094b \u0915\u092e \u0915\u0930\u0928\u0947 \u092e\u0947 \u0938\u0939\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948 , \u0938\u093e\u0925 \u0939\u0940 \u092e\u0947 \u0939\u092e Inbuild Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092d\u0940 \u0905\u092a\u0928\u093e \u0938\u092e\u092f \u092c\u091a\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0914\u0930 \u091a\u093e\u0939\u0947 \u0924\u094b Custom Function \u092d\u0940 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"#c-1131\">MySQL Inbuild Function<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"#c-1132\">MySQL UDF (User Define Function) <\/a><\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"c-1131\"><strong>1.1.3.1 MySQL Inbuild Function<\/strong><\/h3>\n\n\n\n<p>\u092f\u0939 \u0935\u0947 \u0938\u092d\u0940 Function \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 \u0939\u092e\u0947 MySQL Databse \u0926\u094d\u0935\u093e\u0930\u093e Provide \u0915\u093f\u090f \u091c\u093e\u0924\u0947 \u0939\u0948\u0902, \u0907\u0928\u0915\u093e \u0939\u092e\u0947 \u0915\u0947\u0935\u0932 \u0909\u092a\u092f\u094b\u0917 \u0939\u0940 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0915\u093e\u0930\u094d\u092f \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u092e Function \u0915\u094b Distribute \u0915\u0930\u0947 \u0924\u094b Function 3 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>1.1.3.1.1 MySQL Scaller Function  :<\/strong> \u0910\u0938\u0947 function \u091c\u093f\u0928\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0939\u092e\u0947 \u090f\u0915 \u092b\u0940\u0932\u094d\u0921 \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u092a\u0930 \u0915\u0941\u091b Operation \u0915\u0930 \u090f\u0915 \u0935\u0948\u0932\u094d\u092f\u0942 Return \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0947 Scaler Function \u0915\u0939\u0924\u0947 \u0939\u0948\u0902 \u0907\u0928\u0915\u094b \u092d\u0940 \u092f\u093e\u0926 \u0930\u0916\u0928\u0947 \u092e\u0947 \u0906\u0938\u093e\u0928 \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 Type \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0915\u093f\u090f \u0939\u0948\u0902 \u0964\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-string-function\/\">String Function<\/a> : <\/strong>String \u092f\u093e\u0928\u093f \u0915\u0940 Character Data Type \u092a\u0930 \u0909\u092a\u092f\u094b\u0917 \u0939\u094b\u0928\u0947 \u0935\u093e\u0932\u0947 \u0938\u092d\u0940 Function \u0915\u094b \u0907\u0938\u092e\u0947 \u0932\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948 \u0964 \u091c\u0948\u0938\u0947 String \u0915\u0947 Character Count \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 , \u0926\u094b String \u0915\u094b \u091c\u094b\u095c\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0906\u0926\u093f \u0964 <\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-number-function\/\">Number Function<\/a> :<\/strong> Number Data Type \u092a\u0930 \u0909\u092a\u092f\u092a\u0917 \u0939\u094b\u0928\u0947 \u0935\u093e\u0932\u0947 \u0938\u092d\u0940 Function \u0915\u094b \u0907\u0938 Category \u092e\u0947 \u0932\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948  \u0964 \u091c\u0948\u0938\u0947 Value \u0915\u094b Rounding \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924, Square \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 , \u0905\u0928\u094d\u092f \u0938\u092d\u0940 Mathamatical Calculation \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Functions.    <\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-date-time-function\/\">Date Time Function<\/a> :<\/strong> Date \u0914\u0930 Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Function \u0915\u094b \u0907\u0938 Category \u092e\u0947 \u0932\u093f\u092f\u093e \u0939\u0948\u0902 , \u0907\u0938\u092e\u0947 Date \u092e\u0947 \u0938\u0947 Month Find \u0915\u0930\u0928\u093e , \u092f\u093e Date \u092e\u0947 \u0926\u093f\u0928\u094b\u0902 \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u091c\u094b\u095c \u0915\u0930 \u0905\u0917\u0932\u0940 Date find \u0915\u0930\u0928\u093e \u0906\u0926\u093f \u0907\u0938\u0940 \u0924\u0930\u0939 \u0938\u0947 Time \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Function \u092d\u0940 \u0907\u0938 Category \u092e\u0947 \u0932\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\"><strong>1.1.3.1.2<\/strong> <strong>Aggregate Function<\/strong><\/a><strong> :<\/strong> Aise Function \u091c\u094b \u0915\u0940 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Rows \u0915\u0947 data \u092a\u0930 Calculation \u0915\u0930 \u0935\u0948\u0932\u094d\u092f\u0942 Return \u0915\u0930\u0924\u0947 \u0939\u094b \u0909\u0928\u094d\u0939\u0947 Aggregate Function \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u0947 \u0915\u0940 \u092c\u0939\u0941\u0924 \u0938\u0947 \u0938\u0902\u0916\u094d\u092f\u093e\u0913 \u092e\u0947 \u0938\u0947 Minimum value Calculate \u0915\u0930\u0928\u093e , Max, Sum, Count \u0906\u0926\u093f Function \u0907\u0938 Category \u092e\u0947 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\" id=\"block-b8b93042-eedb-4198-893f-9fabaa9d12f4\">\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/window-function-over-clause\/\">1.1.3.1.3 Window Function<\/a> :<\/strong> \u0910\u0938\u0947 Function \u091c\u094b \u0915\u0940 \u0915\u093e\u0930\u094d\u092f \u0924\u094b Aggegate Function \u091c\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0940 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 rows \u092e\u0947 \u0938\u0947 value find \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0927\u093f\u0924 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0938\u093e\u0925 \u092e\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 scaler Return \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u0906\u092a \u0910\u0938\u0947 \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Row \u092a\u0930 Operation Perform \u0915\u0930 \u0909\u0938\u0947 \u0909\u0938\u0940 Data \u0915\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Row \u092a\u0930 display \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0928\u092e\u0947 \u092d\u0940 \u0926\u094b \u0924\u0930\u0939 \u0915\u0947 Function \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964\n<ul class=\"wp-block-list\">\n<li><strong>Window Aggregate Function :<\/strong> Count, Sum, Min, Max \u0906\u0926\u093f Function \u0907\u0938\u092e\u0947 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li>\n\n\n\n<li><strong>Window Analytical Function :<\/strong> Rank Find \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Function \u0907\u0938\u092e\u0947 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"c-1132\"><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">1.1.3.2 MySQL UDF (User Define Function)<\/a><\/strong><\/h3>\n\n\n\n<p>\u092f\u0926\u093f \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Function \u0938\u0947 \u0905\u0924\u093f\u0930\u093f\u0915\u094d\u0924 \u0939\u092e\u093e\u0930\u0940 \u0915\u094b\u0908 Requirement \u0939\u094b \u0924\u094b \u0939\u092e \u0938\u094d\u0935\u092f\u0902 \u0905\u092a\u0928\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u091c\u094b Funcion \u092c\u0928\u093e\u090f \u0909\u0928\u094d\u0939\u0947 UDF (User Define Function) \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0939\u092e \u0905\u092a\u0928\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 SQL Command \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/Z7qUOJdvxmQ\" target=\"_blank\" rel=\"noopener\">Related Video : : MySQL Stored Function | MySQL UDF &#8211; User Define Function in Hindi<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">Read More&#8230;<\/a><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-114\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">1.1.4 Procedure<\/a><\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Program \u092c\u0928\u093e\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e Stored Procedure \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u090f\u0915 Procedure \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0939\u092e Database \u0938\u0947 Related \u0938\u092d\u0940 Operation Perform \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u0914\u0930 \u091c\u092c \u0939\u0940 \u0939\u092e\u0947 \u091c\u092c Procedure \u0915\u094b \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b \u0924\u094b \u0915\u0947\u0935\u0932 Procedure \u0915\u094b Call \u0915\u0930\u0928\u093e \u0939\u0940 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964  \u0907\u0938\u092e\u0947 Parameter Passing \u0906\u0926\u093f \u092d\u0940 \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/8yX3_ZOkECI\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Stored Procedure in Hindi | IN, OUT, INOUT With Example<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">Read More&#8230;<\/a><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"c-115 wp-block-heading\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\">1.1.5 Trigger<\/a><\/h2>\n\n\n\n<p>Trigger \u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 \u0939\u092e \u091c\u092c \u092d\u0940 \u0915\u093f\u0938\u0940 \u091f\u0947\u092c\u0932 \u091c\u093f\u0938 \u092a\u0930 \u0915\u0940 \u0939\u092e Trigger \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 Insert \/Update\/Delete \u092e\u0947 \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 Command Execute \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0924\u092c Trigger Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902, Trigger \u092e\u0947 \u0939\u092e \u091c\u093f\u0938 Table \u0938\u0947 Call \u0939\u0941\u0935\u093e \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u0914\u0930 \u0915\u093f\u0938\u0940 \u0905\u0928\u094d\u092f Table \u092a\u0930 \u092d\u0940 \u0939\u092e \u0915\u094b\u0908 Operation \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0947 \u0924\u094b \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Timing \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Trigger \u0926\u094b \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Before Trigger :<\/strong> Table \u092e\u0947 Data Insert \u0939\u094b\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u092f\u0939 Trigger Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 \u091c\u092c \u0939\u092e  \u091c\u093f\u0938 \u091f\u0947\u092c\u0932 \u092a\u0930 Trigger \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0940 \u092a\u0930 \u0915\u0941\u091b \u092d\u0940 Update \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e \u092f\u0939 Trigger \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 <\/li>\n\n\n\n<li><strong>After Trigger : <\/strong>Table \u092e\u0947 Data Insert \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u092f\u0939 Trigger execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0915\u094b\u0908 \u092d\u0940 after Trigger \u0938\u0947 \u0939\u092e Self Table \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u093f\u0938 \u092a\u0930 Trigger \u0932\u093f\u0916 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 <strong>Insert\/update<\/strong> \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><strong>Event \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Trigger \u0924\u0940\u0928 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Insert Trigger :<\/strong> \u091c\u092c \u092d\u0940 Table \u092e\u0947 \u0915\u094b\u0908 New Row Insert \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Trigger Execute \u0939\u094b\u0924 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>Update Trigger :<\/strong> \u091c\u092c \u092d\u0940 Table \u092e\u0947 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092e\u094c\u091c\u0942\u0926 Row \u092e\u0947 \u0915\u093f\u0938\u0940 \u090f\u0915 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0906\u0927\u093f\u0915 Column \u092e\u0947 \u0915\u094b\u0908 Update \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Trigger Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li><strong>Delete Trigger :<\/strong> \u091c\u092c \u092d\u0940 \u0915\u093f\u0938\u0940 Row \u0915\u094b Delete \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Trigger Execute \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0926\u094b\u0928\u094b\u0902 Combination \u0938\u0947 \u0939\u092e 6 Trigger \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u0907\u0938\u0932\u093f\u090f MySQL \u092e\u0947 \u0939\u092e \u090f\u0915 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0905\u0927\u093f\u0915\u0924\u092e 6 Trigger \u0939\u0940 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Before Insert <\/li>\n\n\n\n<li>Before Update <\/li>\n\n\n\n<li>Before Delete <\/li>\n\n\n\n<li>After Insert<\/li>\n\n\n\n<li>After Update <\/li>\n\n\n\n<li>After Delete <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/OjHl80NQ7Bk\" data-type=\"URL\" data-id=\"https:\/\/youtu.be\/OjHl80NQ7Bk\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Trigger in Hindi | Trigger Kaise Banaye<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\">Read More&#8230;<\/a><\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-116\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-index\/\">1.1.6 Index<\/a><\/h2>\n\n\n\n<p>\u092f\u0939 \u090f\u0915 Techinque \u0939\u0948\u0902 \u091c\u093f\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e \u091c\u093f\u0938 Record \u0915\u094b Access \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u0915\u092e \u0938\u0947 \u0915\u092e Step \u092e\u0947\u0902 \u092a\u0939\u0941\u0901\u091a \u0938\u0915\u0947\u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Record Search \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u092c\u0939\u0941\u0924 \u091c\u0932\u094d\u0926\u0940 \u0939\u092e\u0947\u0902 \u092e\u093f\u0932 \u0938\u0915\u0947 \u0964<\/p>\n\n\n\n<p>\u091c\u092c database Table \u092e\u0947\u0902 Record \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u092c\u0939\u0941\u0924 \u0905\u0927\u093f\u0915 \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 \u0924\u092c \u092f\u0926\u093f \u0915\u093f\u0938 Record \u0915\u094b Search \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b Sequential Search \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u092e\u092f \u0932\u0917\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f Record \u0915\u093f\u0938 \u092d\u0940 Indexing Technique \u0938\u0947 Sort \u0939\u094b\u0902\u0917\u0947 \u0924\u094b Database \u0926\u094d\u0935\u093e\u0930 \u0909\u0928\u094d\u0939\u0947\u0902 Search \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0915\u092e \u0938\u092e\u092f \u0932\u0917\u0947\u0917\u093e \u0964<\/p>\n\n\n\n<p>\u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 MySQL \u0915\u0947 Index \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0938\u092e\u091d\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e Index \u0915\u094b \u0926\u094b \u092d\u093e\u0917\u094b \u092e\u0947\u0902 Divide \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th scope=\"col\"><strong>CLUSTERED INDEX<\/strong><\/th><th><strong>NON CLUSTERED INDEX<\/strong><\/th><\/tr><\/thead><tbody><tr><td>Primary Index<\/td><td>Simple Index or Index<\/td><\/tr><tr><td>Unique Index or Unique<\/td><td>Spatial Index (like Geo Columns)<\/td><\/tr><tr><td><\/td><td>FullText index (For Char, Varchar, Text)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/xZ2j5z02sHM\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Index | Learn About Clustered Index and Non Clustered Index<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right\"><a href=\"https:\/\/selfimagination.in\/tips\/mysql-index\/\"><strong>Read More&#8230;<\/strong><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"c-117\">1.1.7 Event<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 MySQL \u092e\u0947 \u0915\u093f\u0938\u0940 Task \u0915\u094b Schedule \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u0915\u0939\u0947 \u0915\u0940 \u0915\u093f\u0938\u0940 Specific Date \u0914\u0930 Time \u092a\u0930 \u0915\u094b\u0908 Task Execute \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e MySQL Event \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a\u0915\u094b Windows \u0915\u0947 Task Schedule \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0939\u0948\u0902 \u0924\u094b \u0938\u092e\u091d\u094b \u0915\u0940 Event \u092d\u0940 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0935\u0939\u0940 \u0939\u0948\u0902  \u0915\u0947\u0935\u0932 \u092f\u0939 MySQL Database \u0915\u0947 Internal Task \u0939\u0940 Handel \u0915\u0930\u0924\u0940 \u0939\u0948\u0902 <\/p>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b External Task Handle \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b <a href=\"https:\/\/selfimagination.in\/tips\/mysql-sys-exec-example-with-trigger\/\">MySQL SYS_EXE<\/a> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>Event \u0915\u094b \u0906\u092a Globally On\/Off \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f \u0906\u092a \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 Active Schedule \u0939\u0948\u0902 \u0938\u092d\u0940 Inactive \u0939\u094b \u091c\u093e\u090f \u0924\u094b \u0906\u092a Single Click \u0938\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 Inactive \u0915\u094b Activate \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>Share Web Server \u0915\u0947 Case \u092e\u0947 \u091c\u0939\u093e \u0924\u0915 \u092e\u0941\u091d\u0947 \u092f\u093e\u0926 \u0939\u0948\u0902 \u0906\u092a\u0915\u094b Event Create \u0915\u0930\u0928\u0947 \u0915\u0940 permission \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/wntWuykHVus\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Event (Event Type, On Completion Preserve)<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. MySQL Command <\/h2>\n\n\n\n<p>MySQL \u092f\u093e \u0915\u093f\u0938\u0940 \u092d\u0940 Database \u092e\u0947 Command \u0915\u094b \u0939\u092e 4 \u092f\u093e 5 \u092d\u093e\u0917\u094b\u0902 \u092e\u0947 Divide \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 Command \u0915\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u092c\u093e\u0902\u091f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#21\">DDL (Data Defination Language)<\/a><\/li>\n\n\n\n<li><a href=\"#22\">DML (Data Manupulation Language)<\/a> <\/li>\n\n\n\n<li><a href=\"#23\">DQL (Data Query Language)<\/a><\/li>\n\n\n\n<li><a href=\"#24\">DCL (Data Control Language)<\/a><\/li>\n\n\n\n<li><a href=\"#25\">TCL  (Transaction Control Language)<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"21\">2.1 DDL (Data Defination Language)<\/h2>\n\n\n\n<p>Database Schema \u0915\u094b \u092c\u0928\u093e\u0928\u0947, \u0909\u0938\u092e\u0947 \u092c\u0926\u0932\u093e\u0935 \u0915\u0930\u0928\u0947 \u0914\u0930 \u0909\u0938\u0947 Delete \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0938\u092d\u0940 Command \u0915\u094b DDL Command \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0947 \u092d\u0940 \u0939\u092e \u0926\u094b \u092d\u093e\u0917 \u092e\u0947 Divide \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><strong>Table DDL Command :<\/strong> Data Table \u092e\u0947 Store \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u0914\u0930 Table Database \u092e\u0947 , Index \u092d\u0940 \u090f\u0915 \u0905\u0932\u0917 location \u092a\u0930 Sequence \u0915\u094b store \u0915\u0930 \u0930\u0916\u0924\u0947 \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0907\u0928 \u0924\u0940\u0928\u094b\u0902 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0938\u092d\u0940 Command \u0915\u094b Table DDL Command \u0915\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0939 Direct Storage \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-database-phpmyadmin\/\"><strong>DATABASE<\/strong><\/a>\n<ul class=\"wp-block-list\">\n<li>CREATE DATABASE<\/li>\n\n\n\n<li>ALTER DATABASE<\/li>\n\n\n\n<li>DROP DATABASE<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">TABLE<\/a><\/strong>\n<ul class=\"wp-block-list\">\n<li>CREATE TABLE<\/li>\n\n\n\n<li>ALTER TABLE<\/li>\n\n\n\n<li>DROP TABLE<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-index\/\">INDEX<\/a><\/strong>\n<ul class=\"wp-block-list\">\n<li>CREATE INDEX<\/li>\n\n\n\n<li>DROP INDEX<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Non-Table DDL Command :<\/strong> \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0924\u0940\u0928\u094b\u0902 \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0905\u0928\u094d\u092f \u0938\u092d\u0940 \u0915\u0947 Structure \u0915\u094b \u092c\u0928\u093e\u0928\u0947 \u0914\u0930 \u092c\u0926\u0932\u093e\u0935 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Non-Table DDL Command \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-view\/\">VIEW<\/a><\/strong>\n<ul class=\"wp-block-list\">\n<li>CREATE VIEW<\/li>\n\n\n\n<li>ALTER VIEW<\/li>\n\n\n\n<li>DROP VIEW<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">FUNCTION<\/a><\/strong><ul><li>CREATE FUNCTION<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>DROP FUNCTION<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">PROCEDURE<\/a><\/strong><ul><li>CREATE PROCEDURE<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>DROP PROCEDURE<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/selfimagination.in\/tips\/mysql-trigger\/\">TRIGGER<\/a><\/strong>\n<ul class=\"wp-block-list\">\n<li>CREATE TRIGGER<\/li>\n\n\n\n<li>DROP TRIGGER <\/li>\n<\/ul>\n<\/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=\"22\">2.2 DML (Data Manupulation Language) <\/h2>\n\n\n\n<p>Table Structure \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0909\u0938\u092e\u0947 Data Insert \u0915\u0930\u0928\u093e, \u0909\u0938\u092e\u0947 \u0915\u094b\u0908 Change \u0915\u0930\u0928\u093e \u092f\u093e \u0909\u0938\u0947 Delete \u0915\u0930\u0928\u093e \u0907\u0928 \u0938\u092d\u0940 \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 Command DML Statement \u0915\u0947 \u0905\u0902\u0924\u0930\u094d\u0917\u0924 \u0906\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-insert\/\">INSERT INTO &lt;TableName&gt;<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-update\/\">UPDATE &lt;TableName&gt;<\/a> <\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-delete-truncate\/\">DELETE &lt;TableName&gt;<\/a> <\/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=\"23\">2.3 DQL (Data Query Language)<\/h2>\n\n\n\n<p>\u0935\u0948\u0938\u0947 DQL \u092d\u0940 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 DML \u0915\u093e \u0939\u0940 \u0939\u093f\u0938\u094d\u0938\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0939\u092e Command \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b \u0921\u093e\u091f\u093e \u0939\u092e\u0928\u0947 \u091f\u0947\u092c\u0932 \u092e\u0947 Store \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0909\u0938 \u0938\u0947 \u0905\u092a\u0928\u0940 \u091c\u0930\u0942\u0930\u0924 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Get \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0938\u0947 Query Fire \u0915\u0930\u0928\u093e \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u092e\u0941\u0916\u094d\u092f \u0930\u0942\u092a \u0938\u0947 Select command \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 \u0905\u0928\u094d\u092f \u0938\u092d\u0940 command Select \u0915\u0940 \u0938\u0939\u092f\u094b\u0917\u0940 command \u0939\u0948\u0902 \u0964 \u0907\u0938\u0940 \u0915\u092e\u093e\u0902\u0921 \u0915\u0947 \u0938\u093e\u0925 \u0939\u092e Function \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/select-example\/\">SELECT<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/from-clause-in-myql\/\">FROM<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/where-clause-in-mysql\/\">WHERE<\/a><\/li>\n\n\n\n<li>GROUP BY<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/having-clause-in-mysql\/\">HAVING<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/order-by-clause-in-mysql\/\">ORDER BY<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>SELECT DISTINCT<\/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=\"24\">2.4 DCL (Data Control Language)<\/h2>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u091c\u094b User \u092c\u0928\u093e\u090f \u0939\u0948\u0902 \u0909\u0928\u0915\u094b Permisstion \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Control Language \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>GRANT :<\/strong> User \u0915\u094b Permisstion \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <\/li>\n\n\n\n<li><strong>REVOKE : <\/strong>User \u0915\u094b \u0926\u0940 \u0917\u0908 Permission \u0939\u091f\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/Rp0-yjSVx68\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL User Management | CREATE \/ ALTER \/ DROP \/ GRANT \/ REVOKE<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"25\">2.5 TCL  (Transaction Control Language)<\/h2>\n\n\n\n<p>\u091c\u092c \u0939\u092e \u0915\u0941\u091b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 SQL \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u092c\u0940\u091a \u092e\u0947 \u0915\u093f\u0938\u0940 \u0915\u093e\u0930\u0923 \u0938\u0947 Process Block \u0939\u094b\u0928\u0947 \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b Execution \u0915\u093f\u090f \u0939\u0948\u0902 \u0935\u0939 reverse \u0939\u094b \u091c\u093e\u090f \u0924\u092c \u0939\u092e TCL \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u092e\u0941\u0916\u094d\u092f \u0930\u0942\u092a \u0938\u0947 \u0926\u094b Command \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>COMMIT :<\/strong> \u0939\u092e \u091c\u094b \u092d\u0940 Insert \/Update \/Delete Command Execute \u0915\u0930\u0947 \u0924\u094b \u0935\u0939 Database \u092e\u0947 Effect \u0924\u094b \u0915\u0930\u0947\u0917\u0940 \u0932\u0947\u0915\u093f\u0928 \u0935\u0939 Temparary Store \u0939\u094b\u0917\u0940 \u0964 \u091c\u092c \u0939\u092e Commit Command Execute \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u092c Execute \u0915\u093f\u090f Command Database \u092e\u0947 Permanent Store \u0939\u094b \u091c\u093e\u090f\u0902\u0917\u0947 \u0964 <\/li>\n\n\n\n<li><strong>ROLLBACK :<\/strong> \u091c\u0948\u0938\u0947 \u0915\u0940 \u0939\u092e\u0928\u0947 Commit \u092e\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 \u0926\u0940 \u0917\u0908 Command \u0915\u094b Permanenty Store \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u093e \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0909\u0932\u094d\u091f\u093e \u0915\u093e\u0930\u094d\u092f Rollback \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u0907\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 \u091c\u094b \u092d\u0940 Insert \/ Update \/ Delete Execute \u0915\u0940 \u0939\u0948\u0902 \u0909\u0928\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u091c\u094b \u092d\u0940 Database \u092e\u0947 temparay Changes \u0915\u093f\u090f \u0925\u0947 \u0935\u0939 \u0939\u091f \u091c\u093e\u090f\u0902\u0917\u0947 \u0914\u0930 Database \u092a\u0941\u0930\u093e\u0928\u0940 \u0935\u093e\u0932\u0940 State \u092a\u0930 \u0906 \u091c\u093e\u090f\u0917\u093e\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\">\u0938\u0940\u0916\u0947 VIDEO \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947 Programming \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f&nbsp;<a href=\"https:\/\/www.youtube.com\/channel\/UCHLuWJ4xcq70qvWgog4YSrg\" target=\"_blank\" rel=\"noreferrer noopener\">Imagination Code Channel<\/a>&nbsp;\u0915\u094b Subscribe \u0915\u0930\u0947\u0964<\/li>\n\n\n\n<li><a href=\"https:\/\/t.me\/tutorialforlearnmysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Telegram Channel<\/a>&nbsp;\u0938\u0947 \u091c\u0941\u0921\u093c\u0947 \u0914\u0930 \u092a\u093e\u090f Article &amp; Video \u092a\u094d\u0930\u0924\u093f\u0926\u0940\u0928<\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=dwKr33RG3UA&amp;list=PLhJ6tQK0qIcOLAiCWg00L79euGSNVoVno\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Beginner &amp; Advance Playlist in Hindi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/dwKr33RG3UA\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Overview in One Video<\/a><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 <strong>MySQL Overview<\/strong> \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092e\u0941\u091d\u0947 \u0915\u092e\u0947\u0928\u094d\u091f \u0915\u0930 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f \u0964 <\/p>\n\n\n\n<p>\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 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><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\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u092f\u0926\u093f \u0906\u092a \u092f\u0939 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 MySQL Overview Read \u0915\u0930\u0928\u0947 \u0906\u090f \u0939\u0948 \u0907\u0938\u0915\u0947 \u0926\u094b \u0915\u093e\u0930\u0923 \u0939\u094b \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u092a\u0939\u0932\u093e \u0915\u0940 \u0906\u092a Programming \u0915\u0940 \u0926\u0941\u0928\u093f\u092f\u093e \u092e\u0947 \u092a\u0939\u0932\u0947 \u0938\u0947 \u0939\u0940 \u0939\u0948\u0902 \u0914\u0930 \u0905\u0928\u094d\u092f Programming Language \u0915\u0947 \u0938\u093e\u0925 \u0906\u092a SQL \u092d\u0940 \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0926\u0942\u0938\u0930\u093e \u0915\u093e\u0930\u0923 \u092f\u0939 \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a\u0928\u0947 \u092a\u094d\u0930\u094b\u0917\u094d\u0930\u093e\u092e\u093f\u0902\u0917 \u0938\u0940\u0916\u0928\u093e \u0936\u0941\u0930\u0942 \u0939\u0940 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0914\u0930 \u0906\u092a SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8917,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16,5],"tags":[],"class_list":["post-8745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-overview","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/mysql-overview.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8745","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=8745"}],"version-history":[{"count":200,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8745\/revisions"}],"predecessor-version":[{"id":9513,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8745\/revisions\/9513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/8917"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=8745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=8745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=8745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}