{"id":1866,"date":"2021-07-21T14:51:56","date_gmt":"2021-07-21T09:21:56","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=1866"},"modified":"2022-01-07T20:22:16","modified_gmt":"2022-01-07T14:52:16","slug":"mysql-trigger","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-trigger\/","title":{"rendered":"MySQL Trigger"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>DBMS MySQL Trigger in Hindi<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">MySQL Trigger \u0915\u094b \u092f\u0926\u093f \u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 \u0938\u092e\u091d\u0947 \u0924\u094b \u092f\u0939 \u090f\u0915 \u0910\u0938\u093e \u0938\u093f\u0938\u094d\u091f\u092e \u0939\u0948\u0902 \u091c\u093f\u0938\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 Table \u092a\u0930 Set \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 \u0909\u0938 \u091f\u0947\u092c\u0932 \u092a\u0930 \u0915\u094b\u0908 \u092d\u0940 Operation \u091c\u0948\u0938\u0947 Insert Update \u0914\u0930 Delete perform \u0939\u094b\u0924\u0947 \u0939\u0940 \u092f\u0939 Trigger Call \u0939\u094b \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 , \u0914\u0930 \u091c\u094b \u092d\u0940 \u0939\u092e\u0928\u0947 Trigger \u092e\u0947\u0902 Code \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u092f\u0939 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0928\u0947 \u0932\u0917\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\">What is trigger in MySQL?  <\/h2>\n\n\n\n<p>Trigger \u0915\u094b \u092f\u0926\u093f \u0939\u092e\u0947 \u0938\u092e\u091d\u0947 \u0924\u094b \u092f\u0939 Gun \u0915\u0947 Button \u0939\u0940 \u0939\u0948\u0902 \u091c\u0940\u0938\u0947 \u091c\u0948\u0938\u0947 \u0939\u0940 \u0939\u092e Press \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 Gun \u092e\u0947 \u0938\u0947 Bullet \u0928\u093f\u0915\u0932\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 Table \u092a\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 Insert \/ Update \/ Delete \u092e\u0947 \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 Operation \u0939\u094b\u0917\u093e \u0935\u0948\u0938\u0947 \u0939\u0940 Trigger Execute \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<p>\u0939\u092e \u090f\u0915 \u091f\u0947\u092c\u0932 \u092a\u0930 Maximum 6 Triggers \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 (Max 6 triggers in MySQL on a table) <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL Trigger Before Insert<\/li><li>MySQL Trigger Before Update<\/li><li>MySQL Trigger Before Delete  <\/li><li>MySQL Trigger After Insert<\/li><li>MySQL Trigger After Update<\/li><li>MySQL Trigger After Delete  <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Advantage of MySQL Trigger<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Reduce Work :<\/strong> Programmer \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u092c\u0939\u0941\u0924 \u0906\u0938\u093e\u0928 \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u090f\u0915 \u092c\u093e\u0930 \u0932\u093f\u0916\u0928\u0947 \u092a\u0930 \u092f\u0939 Automatic \u0939\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u0947 \u0930\u0939\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>Validation Checking : <\/strong>\u092f\u0926\u093f \u0939\u092e Before Trigger \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e Table \u092e\u0947\u0902 Entry \u0939\u094b\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0909\u0938 \u092a\u0930 Validation Check \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><strong>Mobile &amp; Web :<\/strong> \u091c\u092c \u0939\u092e \u090f\u0915 \u0939\u0940 \u090f\u092a\u094d\u0932\u0940\u0915\u0947\u0936\u0928 \u0915\u094b Mobile \u0914\u0930 Web \u092e\u0947\u0902 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092c\u0939\u0941\u0924 \u0938\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 Trigger \u0915\u093e\u092e \u092e\u0947\u0902 \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0915\u094d\u092f\u0941\u0915\u0940 \u0907\u0938\u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 \u091c\u094b Common Coding \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0915\u094b \u0939\u092e PHP \u0938\u0947 database \u092e\u0947\u0902 \u0936\u093f\u092b\u094d\u091f \u0915\u0930 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0935\u0939 Coding \u0939\u092e\u0947\u0902 \u0926\u094b\u0928\u094b\u0902 Frontend (Web \u0914\u0930 Mobile) \u092a\u0930 \u0915\u093e\u092e \u0906 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964<\/li><li><strong>Fast :<\/strong> \u091f\u094d\u0930\u093f\u0917\u0930 \u092c\u0939\u0941\u0924 <strong>Fast<\/strong> \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u092f\u0926\u093f \u090f\u0915 <strong>Table<\/strong> \u0915\u0947 <strong>Data<\/strong> \u0915\u094b \u0905\u0932\u0917 \u0905\u0932\u0917 <strong>Table<\/strong> \u092e\u0947\u0902 \u092a\u0939\u0941\u0902\u091a\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e \u092c\u0939\u0941\u0924 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0915\u0941\u091b \u092d\u0940 Calculation \u0915\u0930 <strong>Data<\/strong> \u0915\u094b \u0926\u0942\u0938\u0930\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u092a\u0902\u0939\u0941\u091a\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL Trigger Syntax Example<\/strong> (Create Trigger MySQL)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\n drop trigger &lt;TriggerName&gt; $$\n CREATE TRIGGER &lt;TriggerName&gt; BEFORE\/AFTER INSERT\/UPDATE\/DELETE ON TableName\n for each row \nBEGIN\n\n\/* Write your Logic ;*\/ \n\n\nEND;\n$$\nDELIMITER ;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>DELIMITER <\/strong><\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">MySQL \u092e\u0947\u0902 \u092d\u0940 \u0915\u094b\u0908 \u092d\u0940 Syntax \u0915\u094b Close \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f ; (semicolon) \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 , \u0914\u0930 \u091f\u094d\u0930\u093f\u0917\u0930 \/ Function \u0915\u094b Close \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 ; (Semicolon) \u0915\u0940 \u0939\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 , \u092f\u0926\u093f \u0939\u092e \u0926\u094b\u0928\u094b\u0902 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 ; (Semicolon) \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b System \u092f\u0939 \u092a\u0924\u093e \u0928\u0939\u0940\u0902 \u0932\u0917\u093e \u092a\u093e\u092f\u0947\u0917\u093e \u0915\u0940 Start \u0915\u0939\u093e \u0938\u0947 \u0939\u0941\u0906 \u0939\u0948\u0902 \u0914\u0930 End \u0915\u0939\u093e \u092a\u0930 \u0939\u0941\u0906 \u0939\u0948\u0902 \u0964 Delimiter \u0932\u0917\u093e \u0915\u0930 \u0939\u092e System \u0915\u094b \u092f\u0939 \u092c\u0924\u093e \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e \u091c\u094b \u092d\u0940 \u0928\u093f\u091a\u0947 Syntax \u0932\u093f\u0916 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 $$ \u0938\u0947 \u0915\u094d\u0932\u094b\u091c \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 \u0914\u0930 Coding \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u092b\u093f\u0930 \u0938\u0947 \u0939\u092e Delimiter \u092e\u0947\u0902 ; (Semicolon) \u0938\u0947 \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 \u091c\u094b \u092d\u0940 \u0939\u092e BEGIN Or END \u0915\u0947 \u092c\u093f\u091a \u092e\u0947\u0902 \u0939\u092e\u093e\u0930\u0947 Logic \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0909\u0938\u092e\u0947 \u0939\u092e\u0947\u0902 ; Semicolon \u0915\u093e \u0939\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964<\/p>\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\"><strong>DROP TRIGGER &lt;TRIGGER NAME><\/strong> (Delete Trigger MySQL)<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Drop Trigger MySQL : \u091c\u092c \u0939\u0940 \u0939\u092e First Time Trigger \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Syntax Error \u0926\u0947\u0917\u093e \u0915\u094d\u092f\u0941\u0915\u0940 \u0905\u092d\u0940 Trigger \u092c\u0928\u093e \u0939\u0940 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 , \u0932\u0947\u0915\u093f\u0928 Second Time Execute \u0915\u0930\u0928\u0947 \u092a\u0930 Error \u0928\u0939\u0940\u0902 \u0906\u090f\u0917\u0940 \u0915\u094d\u092f\u0941\u0915\u0940 \u0905\u092c \u091f\u094d\u0930\u093f\u0917\u0930 \u092c\u0928 \u091a\u0942\u0915\u093e \u0939\u0948\u0902 , \u0910\u0938\u093e \u0907\u0938\u0932\u093f\u090f \u0932\u093f\u0916\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0939\u092e\u0947\u0902 \u091c\u092c \u092d\u0940 \u091f\u094d\u0930\u093f\u0917\u0930 \u092e\u0947\u0902 Change \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 Changes \u0915\u0930 \u0932\u0947 \u0964 <\/p>\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\"><strong>CREATE TRIGGER &lt;TRIGGER NAME&gt;<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u093f\u0938 \u092d\u0940 \u0928\u093e\u092e \u0938\u0947 \u0939\u092e\u0947\u0902 \u091f\u094d\u0930\u093f\u0917\u0930 \u092c\u0928\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0928\u093e\u092e \u0915\u093e Angle Braces \u092e\u0947\u0902 \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0928\u093e\u092e \u092a\u0941\u0930\u0947 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u092f\u0942\u0928\u093f\u0915 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0947\u0936\u093e Trigger \u0915\u0947 \u0928\u093e\u092e \u092e\u0947\u0902 Table \u0915\u0947 \u0928\u093e\u092e \u0915\u094b \u0936\u093e\u092e\u093f\u0932 \u0915\u0930 \u0932\u0947\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0924\u093e\u0915\u093f Unique \u0930\u0939\u0947 \u0964<\/li><li>\u091f\u094d\u0930\u093f\u0917\u0930 \u0915\u0947 \u0928\u093e\u092e \u092e\u0947\u0902 \u0938\u094d\u092a\u0947\u0938 \u0928\u0939\u0940\u0902 \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Trigger \u0915\u0947 \u0928\u093e\u092e \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0930\u0916\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b \u0938\u092e\u091d\u0928\u0947 \u092e\u0947\u0902 \u0906\u0938\u093e\u0928\u0940 \u0939\u094b \u0914\u0930 \u090f\u0915 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u091c\u093f\u0924\u0928\u0947 \u092d\u0940 \u091f\u094d\u0930\u093f\u0917\u0930 \u092c\u0928\u093e\u092f\u0947 \u0938\u092d\u0940 \u0915\u0947 \u0928\u093e\u092e \u0915\u094b \u090f\u0915 Pattern \u0938\u0947 \u0930\u0916\u0947 \u0924\u093e\u0915\u093f \u0906\u092a\u0915\u094b Search \u0915\u0930\u0928\u0947 \u0914\u0930 \u0938\u092e\u091d\u0928\u0947 \u092e\u0947\u0902 \u0906\u0938\u093e\u0928\u0940 \u0939\u094b \u0964<\/li><\/ul>\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\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f Article <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-view\/\">MySQL View<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/loop-in-select-query\/\">Loop in Select Query | Loop in MySQL<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-row-to-column-interchange-trick\/\">MySQL (Row to Column) &amp; (Column to Row ) Interchange Logic<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/update-stock-balance-using-trigger\/\">Update Stock\/Balance Using Trigger<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Trigger Time : BEFORE\/AFTER<\/strong><\/h2>\n\n\n\n<p><strong>\u091f\u094d\u0930\u093f\u0917\u0930 \u0915\u094b \u0939\u092e \u0924\u0930\u0939 \u0938\u0947 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/strong><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>BEFORE<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u0948\u0938\u0947 \u0939\u0940 \u0915\u094b\u0908 \u092d\u0940 <strong>Event<\/strong> \u091c\u0948\u0938\u0947 <strong>Insert\/Update\/Delete<\/strong> Perform \u0939\u094b\u0917\u093e \u0924\u094b \u0909\u0938\u0915\u0947 \u092a\u0939\u0932\u0947 \u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 <strong>Code Execute<\/strong> \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e <strong>BEFORE<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0905\u0927\u093f\u0915\u0924\u0930 Validation \u0915\u0947 \u0932\u093f\u090f BEFORE Trigger \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0926\u093f \u0939\u092e\u0947\u0902 Insert \u0939\u094b\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0915\u093f\u0938\u0940 Key \u0915\u0940 Base \u092a\u0930 \u0915\u0941\u091b \u0921\u093e\u091f\u093e Table \u092e\u0947\u0902 \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e Before \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0926\u093f \u0915\u093f\u0938\u0940 Column \u092e\u0947\u0902 \u0915\u094b\u0908 Calculation \u0915\u0930 \u0935\u0948\u0932\u094d\u092f\u0942 Store \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e Default Value Store \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e <strong>BEFORE<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Same \u091f\u0947\u092c\u0932 \u092a\u0930 Value Update \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>AFTER <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e Insert\/Update\/Delete \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0915\u094b\u0908 Operation Perform \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e AFTER \u091f\u094d\u0930\u093f\u0917\u0930 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0905\u0927\u093f\u0915\u0924\u0930 \u0915\u093f\u0938\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0907\u0938 \u091f\u0947\u092c\u0932 \u0915\u0940 \u092c\u0947\u0938 \u092a\u0930 Status \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 AFTER \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0926\u093f \u0921\u093e\u091f\u093e \u0915\u094b \u0915\u093f\u0938\u0940 \u0914\u0930 Table \u092e\u0947\u0902 \u0932\u0947 \u091c\u093e\u0928\u093e \u0939\u0948\u0902 \u0924\u094b AFTER \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0926\u093f Current \u0921\u093e\u091f\u093e \u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u0915\u094b\u0908 Summary \u0905\u092a\u0921\u0947\u091f \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e AFTER Trigger \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>AFTER \u091f\u094d\u0930\u093f\u0917\u0930 \u0938\u0947 \u0939\u092e Same \u091f\u0947\u092c\u0932 \u0915\u0930 \u0915\u094b\u0908 Operation Perform \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947, \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u093f\u0938 table \u092a\u0930 \u0939\u092e Trigger \u0932\u093f\u0916 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u0940 \u091f\u0947\u092c\u0932 \u092a\u0930 Insert\/Update\/Delete \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0964<\/li><\/ul>\n\n\n\n<p><strong>Other Points<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c \u092d\u0940 \u091f\u094d\u0930\u093f\u0917\u0930 \u0915\u093e \u0928\u093e\u092e \u0930\u0916\u0947 \u0924\u094b \u0909\u0938\u092e\u0947 After\/Before \u0915\u094b \u092d\u0940 \u0936\u093e\u092e\u093f\u0932 \u0915\u0930\u0947 \u0924\u093e\u0915\u093f Unique \u0928\u093e\u092e \u0930\u0916\u093e \u091c\u093e \u0938\u0915\u0947 \u0964<\/li><li>\u0906\u092a \u091c\u092c \u092d\u0940 \u0928\u093e\u092e \u0930\u0916\u0947 \u0924\u094b \u091c\u0930\u0941\u0930\u0940 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u0915\u0940 \u092a\u0942\u0930\u093e After \u092f\u093e Before \u0932\u093f\u0916\u0947 \u0907\u0928\u0915\u0947 Short Form \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u0948\u0938\u0947 A\/B \u0906\u0926\u093f \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Trigger Event : INSERT\/UPDATE\/DELETE<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL \u092e\u0947\u0902 \u090f\u0915 \u091f\u094d\u0930\u093f\u0917\u0930 \u092a\u0930 \u090f\u0915 \u0938\u092e\u092f \u092a\u0930 \u0939\u092e INSERT\/UPDATE\/DELETE \u092e\u0947\u0902 \u0938\u0947 \u0915\u094b\u0908 \u090f\u0915 \u0939\u0940 Operation Perform \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Trigger \u0915\u0947 \u0928\u093e\u092e \u0930\u0916\u0924\u0947 \u0938\u092e\u092f \u091a\u093e\u0939\u0947 \u0924\u094b \u0906\u092a <strong>ins\/upd\/del<\/strong> postfix \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Update Trigger in MySQL : \u091c\u092c \u0939\u092e \u0915\u0947\u0935\u0932 Update Trigger \u0939\u0940 \u0932\u093f\u0916\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0909\u0938\u0947 Update Trigger \u0915\u0939\u093e\u0901 \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>ON &lt;TableName&gt;<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u093f\u0938 Table \u092a\u0930 \u0939\u092e Trigger \u0932\u093f\u0916 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u093e \u0928\u093e\u092e \u092f\u0939\u093e\u0901 \u092a\u0930 \u0932\u093f\u0916\u0924\u0947 \u0939\u0948 \u0964<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Trigger Body : BEGIN &#8230; END<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0939 \u091f\u094d\u0930\u093f\u0917\u0930 \u0915\u0940 BODY \u0939\u0948\u0902 \u0907\u0938\u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u091c\u094b \u092d\u0940 SQL \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0935\u0947\u0930\u093f\u090f\u092c\u0932 \u0921\u093f\u092b\u093e\u0907\u0928 \u0915\u0930\u0928\u093e <\/li><li>\u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0940 \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u0928\u093e <\/li><li><strong>SQL<\/strong> \u0915\u0947 Statement \u0932\u093f\u0916\u0928\u093e \u091c\u0948\u0938\u0947 SELECT\/UPDATE\/DELETE<\/li><li>SET \u0914\u0930 <strong>NEW\/OLD<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>SET<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 \u0915\u0940\u0935\u0930\u094d\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0939\u092e \u0905\u0927\u093f\u0915\u0924\u0930 Before Trigger \u092e\u0947\u0902 \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0964 Trigger \u092e\u0947\u0902 \u091c\u093f\u0938 \u092d\u0940 Table \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0938\u092d\u0940 Column \u090f\u0915 Buffer \u092e\u0947\u0902 \u0906 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 \u0909\u0928 \u092a\u0930 Value Set \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e SET Keyword \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Extension : <strong>OLD\/NEW<\/strong> : <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 Buffer \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u091c\u094b \u091f\u0947\u092c\u0932 \u0939\u092e \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 \u0938\u092d\u0940 Column \u0915\u0947 \u0928\u093e\u092e \u0914\u0930 \u0909\u0928\u0915\u0940 value Store \u0930\u0939\u0924\u0940 \u0939\u0948\u0902, Insert \/ Update \u0914\u0930 Delete \u0915\u0947 Case \u092e\u0947\u0902 \u092f\u0939 \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>INSERT :<\/strong> \u0907\u0938\u092e\u0947\u0902 \u0915\u0947\u0935\u0932 <strong>NEW<\/strong> buffer \u0939\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li><strong>UPDATE:<\/strong> \u0907\u0938\u092e\u0947\u0902 OLD \u0914\u0930 NEW Buffer \u0926\u094b\u0928\u094b\u0902 \u0915\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u0935\u0948\u0932\u094d\u092f\u0942 Update \u0939\u094b\u0928\u0947 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0940 Value OLD \u092e\u0947\u0902, \u0914\u0930 Update Hone \u0935\u093e\u0932\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 NEW \u092e\u0947\u0902 Store \u0930\u0939\u0924\u0940 \u0939\u0948\u0902 \u0964<\/li><li><strong>DELETE :<\/strong> \u0907\u0938 \u0915\u0947\u0935\u0932 <strong>OLD<\/strong> Buffer \u0939\u0940 \u0930\u0939\u0924\u093e \u0939\u0948\u0902\u0964<\/li><li><strong>OLD<\/strong> Keyword <strong>Readonly<\/strong> \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0906\u092a \u0907\u0938\u092e\u0947\u0902 \u0915\u094b\u0908 <strong>Change<\/strong> \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947 <\/li><li><strong>NEW<\/strong> Keyword \u092e\u0947\u0902 \u0915\u0947\u0935\u0932 <strong>BEFORE<\/strong> \u0915\u0947 Case \u092e\u0947\u0902 <strong>Changes<\/strong> \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Get Column Name in trigger<\/h3>\n\n\n\n<p><strong>OLD.columnname<\/strong> \u0914\u0930 <strong>NEW.columnname<\/strong> \u0938\u0947 \u0939\u092e Column \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\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 <strong>Trigger Example<\/strong> (Trigger Syntax in MySQL)<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\n DROP TRIGGER mytable_before_insert $$\n CREATE TRIGGER mytable_before_insert BEFORE INSERT ON mytable\n for each row \nBEGIN\n\n\/* \n\nWrite your Logic or SQL Statements;\nend with ; semicolon\n\nSET Variable = Value;\nSET NEW.mycolumnname = value;\n\ninsert into newtable (col1, col2) values (NEW.column1, NEW.column2);\n\n\n*\/ \n\n\n\nEND;\n$$\nDELIMITER ;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/k28XVwqkq4U\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0902\u0939\u093e \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">What problems mysql team face when triggers concept was not there in mysql?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0926\u093f MySQL \u092e\u0947\u0902 Trigger Concept \u0928\u0939\u0940\u0902 \u0939\u094b\u0917\u093e \u0924\u094b Developer \u0915\u094b Front end \u092a\u0930 \u092c\u0939\u0941\u0924 Code \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0902\u0917\u0947 \u0906\u0907\u092f\u0947 \u0938\u092d\u0940 \u092a\u0949\u0907\u0902\u091f \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>Front End \u092a\u0930 \u092c\u0939\u0941\u0924 Coding \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940<\/li><li>Data \u0915\u0940 Entry \u0939\u094b\u0924\u0947 \u0938\u092e\u092f \u091c\u094b Validation \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0928\u0939\u0940\u0902 \u0932\u0917\u093e \u092a\u093e\u092f\u0902\u0917\u0947 \u0964<\/li><li>\u091c\u094b \u0915\u093e\u0930\u094d\u092f \u0939\u092e Auto Table \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0932\u0947 \u091c\u093e \u0915\u0930 Trigger \u0938\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0925\u0947 \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 View \u092f\u093e SQL \u0915\u0940 \u0938\u0939\u093e\u092f\u0924\u093e \u0938\u0947 Query \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0917\u0940 \u091c\u094b Execute \u0939\u094b\u0928\u0947 \u092e\u0947\u0902 \u0938\u092e\u092f \u0932\u0947\u0917\u0940<\/li><li>Trigger Fast \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u0935\u0939 Database \u092e\u0947\u0902 \u0939\u0940 \u0911\u092a\u0930\u0947\u0936\u0928 Perform \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u091c\u092c\u0915\u093f \u092f\u0926\u093f \u092f\u0939\u0940 \u0915\u093e\u0930\u094d\u092f Hum \u0905\u0932\u0917 \u0938\u0947 \u0932\u093f\u0916 \u0915\u0930 \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 Bandwidth \u0914\u0930 Server Speed \u0915\u0947 Issue \u092d\u0940 \u0906 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0915\u0941\u0932 \u092e\u093f\u0932\u0915\u0930 \u0939\u092e \u092f\u0939 \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u092f\u0926\u093f Database \u092e\u0947\u0902 Trigger \u0928\u0939\u0940\u0902 \u0939\u094b\u0902\u0917\u0947 \u0924\u094b \u0921\u0947\u0935\u0932\u092a\u0930 \u0915\u094b Project \u092c\u0928\u093e\u0928\u0947 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u092e\u0947\u0939\u0928\u0924 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940 \u0914\u0930 Project \u092e\u0947\u0902 Efficiency \u0914\u0930 Speed \u0915\u0947 Issue \u0915\u093e \u092d\u0940 \u0938\u093e\u092e\u0928\u093e \u0915\u0930\u0928\u093e \u092a\u0921\u093c\u0947\u0917\u093e \u0964<\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why triggers are developed what would happen if triggers are not there in mysql?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Database \u0915\u0947 performance \u0915\u094b \u092c\u0922\u093c\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Trigger \u0915\u094b \u092c\u0928\u093e\u092f\u093e \u0917\u092f\u093e \u0964<\/li><li>\u091c\u094b \u0915\u093e\u0930\u094d\u092f \u0939\u092e\u0947\u0902 \u092c\u093e\u0939\u0930 \u0938\u0947 database \u092e\u0947\u0902 Perform \u0915\u0930\u0924\u0947 \u0925\u0947 \u0935\u0939 \u0915\u093e\u0930\u094d\u092f \u092f\u0939 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u0930\u0939 \u0915\u0930 \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u091c\u0948\u0938\u0947 \u0939\u0940 \u0939\u092e <strong>Insert\/Update\/Delete<\/strong> \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0935\u0948\u0938\u0947 \u0939\u0940 \u092f\u0939 \u0909\u0928 \u092a\u0930 \u0932\u093f\u0916\u0947 \u0911\u092a\u0930\u0947\u0936\u0928 Perform \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u092c\u093e\u0926 \u0915\u093e SQL Execution \u0915\u093e \u0938\u092e\u092f \u092c\u091a \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>Trigger <strong>Validation<\/strong> \u0915\u0947 \u0932\u093f\u090f \u0915\u093e\u092e \u0906\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-sys-exec-example-with-trigger\/\">\u0906\u091c\u0915\u0932 \u0924\u094b \u0939\u092e \u091f\u094d\u0930\u093f\u0917\u0930 \u0938\u0947 Https Request \u092d\u0940 \u092d\u0947\u091c \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">What is trigger in dbms in hindi ? \/ what is trigger in sql in hindi ?<\/h2>\n\n\n\n<p>\u091c\u093f\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0939\u092e\u0928\u0947 MySQL \u092e\u0947 Trigger \u0932\u093f\u0916\u0947 \u0939\u0948\u0902 \u0935\u0948\u0938\u0947 \u0905\u0928\u094d\u092f DBMS \u092e\u0947 \u092d\u0940 \u0939\u092e Trigger \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u0939\u094b \u0938\u0915\u0924\u093e \u0939\u0948\u0902 Syntax \u092e\u0947 \u0915\u0941\u091b \u0905\u0902\u0924\u0930 \u0939\u094b , Syntax \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0905\u0928\u094d\u092f \u0938\u092d\u0940 \u0935\u093f\u0936\u0947\u0937\u0924\u093e\u090f Trigger \u092e\u0947 \u090f\u0915 \u091c\u0948\u0938\u0940 \u0939\u0940 \u0939\u094b\u0924\u0940 \u0939\u0948 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a\u0915\u0947 <strong>MySQL Trigger<\/strong> \u0938\u0947 \u0938\u092e\u094d\u092c\u0902\u0927\u093f\u0924 \u0915\u094b\u0908 \u092d\u0940 Query \u0939\u094b \u0924\u094b \u0915\u092e\u0947\u0902\u091f \u0915\u0930\u0947 , \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0915\u094b Improve \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 \u092e\u0926\u0926 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092d\u0940 \u0906\u092a \u0915\u092e\u0947\u0902\u091f \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<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<p><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBMS MySQL Trigger in Hindi What is trigger in MySQL? Trigger \u0915\u094b \u092f\u0926\u093f \u0939\u092e\u0947 \u0938\u092e\u091d\u0947 \u0924\u094b \u092f\u0939 Gun \u0915\u0947 Button \u0939\u0940 \u0939\u0948\u0902 \u091c\u0940\u0938\u0947 \u091c\u0948\u0938\u0947 \u0939\u0940 \u0939\u092e Press \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 Gun \u092e\u0947 \u0938\u0947 Bullet \u0928\u093f\u0915\u0932\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 Table \u092a\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 Insert \/ Update \/ Delete \u092e\u0947 \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 Operation \u0939\u094b\u0917\u093e \u0935\u0948\u0938\u0947 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1923,"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-1866","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\/07\/mysql-trigger.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/1866","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=1866"}],"version-history":[{"count":92,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/1866\/revisions"}],"predecessor-version":[{"id":6107,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/1866\/revisions\/6107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/1923"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=1866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}