{"id":750,"date":"2021-03-15T17:24:18","date_gmt":"2021-03-15T11:54:18","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=750"},"modified":"2021-07-22T13:35:09","modified_gmt":"2021-07-22T08:05:09","slug":"mysql-sys-exec-example-with-trigger","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-sys-exec-example-with-trigger\/","title":{"rendered":"MySQL SYS_EXEC Example With Trigger"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a MySQL \u0938\u0947 \u0915\u093f\u0938\u0940 External Exe \u092f\u093e \u0915\u094b\u0908 URL \u0915\u094b \u0915\u0949\u0932 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u0947\u0902 <strong>sys_exec<\/strong> \u0915\u094b \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u092f\u0939 \u090f\u0915 UDF (User Defined Function) \u0939\u0948\u0902,  \u091c\u0948\u0938\u093e \u0915\u0940 \u0939\u092e \u0938\u092d\u0940 \u091c\u093e\u0928\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 MySQL \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 External \u0915\u092e\u093e\u0902\u0921 Direct \u0928\u0939\u0940\u0902 \u091a\u0932\u093e \u0938\u0915\u0924\u0947 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0915\u0941\u091b Steps \u0939\u092e\u0947\u0902 Follow \u0915\u0930\u0928\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 Sys \u0915\u093e \u092e\u0924\u0932\u092c System \u0938\u0947 \u0939\u0948\u0902 \u0914\u0930 Exec \u0915\u093e \u092e\u0924\u0932\u092c Execution \u0938\u0947 \u0939\u0948\u0902, sys_exec \u0915\u094b \u0939\u092e \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 <strong>OS Command In MySQL  <\/strong>\u092d\u0940 \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u0939\u092e \u092f\u0939\u093e\u0901 \u092a\u0930 UDF \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902  <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL <strong>Sys_exec<\/strong> \u0915\u094b Example \u0938\u0947 \u0938\u092e\u091d\u093e\u090f<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>\u0939\u092e \u092e\u093e\u0928 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e\u0947\u0902 \u091c\u092c \u0915\u094b\u0908 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b \u0924\u092c \u0915\u094b\u0908 URL \u0915\u0949\u0932 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 \u091c\u094b Concept \u0909\u092a\u092f\u094b\u0917 \u092e\u0947\u0902 \u0932\u093e\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0930\u0939\u0947\u0917\u093e <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u093f\u0938 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b\u0928\u0947 \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u090f\u0915 \u091f\u094d\u0930\u093f\u0917\u0930 \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0917\u093e <\/li><li>\u091f\u094d\u0930\u093f\u0917\u0930 \u0938\u0947 \u090f\u0915 sys_exec \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0915\u0949\u0932 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e <\/li><li>\u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0939\u092e sys_exec \u092b\u0902\u0915\u094d\u0936\u0928 \u0938\u0947 cURL \u0915\u093e Use \u0915\u0930\u0915\u0947 \u0939\u092e URL \u0915\u0949\u0932 \u0915\u0930 \u0926\u0947\u0902\u0917\u0947 <\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Sys_exec<\/strong> on Shared Server<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Shared Server \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0928\u0939\u0940\u0902 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b Dedicated Server \u0932\u0947\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u092f\u093e \u0906\u092a \u0905\u092a\u0928\u0940 \u0932\u094b\u0915\u0932 \u092e\u0936\u0940\u0928 \u0915\u094b \u0938\u0930\u094d\u0935\u0930 \u092c\u0928\u0935\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/li><li>sys_exec MySQL \u0915\u0947 \u0938\u092d\u0940 Version \u092e\u0947\u0902 \u0928\u0939\u0940\u0902 \u091a\u0932\u0924\u093e \u0914\u0930 \u0907\u0938\u0932\u093f\u090f \u0906\u092a\u0915\u094b MySQL \u0915\u093e 8.0 \u0935\u0930\u094d\u0936\u0928 \u0938\u0947\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e<\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>cURL \u0915\u0940 \u091c\u0930\u0941\u0930\u0924 \u0915\u094d\u092f\u0942 \u0939\u0948\u0902 ?<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0905\u092c \u0939\u092e\u0947\u0902 CURL \u0915\u093e \u0938\u0947\u091f\u0905\u092a \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0915\u094d\u092f\u0941\u0915\u0940 CURL \u0938\u0947 \u0939\u0940 \u0939\u092e \u0915\u093f\u0938\u0940 URL \u0915\u094b \u0915\u0949\u0932 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/li><li>cURL \u0915\u094b \u0939\u092e\u0947\u0902 \u091c\u094b sys_exec \u0938\u0947\u091f\u0905\u092a \u0915\u0940 \u0939\u0948\u0902 \u0909\u0938\u0938\u0947 \u090f\u0915\u094d\u0938\u0947\u0915\u094d\u092f\u0942\u091f\u0947 \u0915\u0930\u0947\u0902\u0917\u0947<\/li><li>URL \u0915\u0949\u0932 \u0915\u0949\u0932 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0939\u092e \u0926\u0942\u0938\u0930\u0947 \u0938\u0930\u094d\u0935\u0930 \u092a\u0930 \u0935\u0939 \u0921\u093e\u091f\u093e \u0938\u0947\u0902\u0921 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u094b \u0907\u0938 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u0941\u0906 \u0925\u093e<\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0928\u093f\u091a\u0947 \u0938\u092d\u0940 \u0938\u094d\u091f\u0947\u092a \u0926\u0940 \u0917\u0908 \u0939\u0948\u0902 \u091c\u0940\u0938\u0947 \u0906\u092a sys_exec \u0915\u094b \u0938\u0947\u091f\u0905\u092a \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Windows Setup <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Window 7 64 Bit <\/li><li>Window Update Service Pack 1 <\/li><li>Dot Net 4.5 <\/li><li>Microsoft Visual C++<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. MySQL Server Setup<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL 64Bit 8.5 (mysql-installer-community-8.0.15.0)<\/li><li><a href=\"https:\/\/dev.mysql.com\/downloads\/installer\/\" target=\"_blank\" rel=\"noopener\">https:\/\/dev.mysql.com\/downloads\/installer\/<\/a><ul><li>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0935\u0947\u092c\u0938\u093e\u0907\u091f \u0938\u0947 \u0906\u092a mysql-installer-community-8.0.15.0 \u0935\u0930\u094d\u0936\u0928 \u092f\u093e \u0907\u0938\u0915\u0947 \u0906\u0938\u092a\u093e\u0938 \u0915\u093e \u0935\u0947\u0930\u094d\u0938\u094d\u091f\u0940\u0913\u0902 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930 \u0932\u0947 <\/li><\/ul><\/li><li>\u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u094b \u092d\u0940 \u0938\u0947\u091f\u0905\u092a \u0915\u0930\u0928\u0947 \u0915\u0947 \u0930\u0942\u0932\u094d\u0938 \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u092b\u0949\u0932\u094b \u0915\u0930\u0924\u0947 \u091c\u093e\u092f\u0947 <\/li><li>\u0938\u0947\u091f\u0905\u092a \u0915\u092e\u094d\u092a\u0932\u0940\u091f \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0932\u0949\u0917\u093f\u0928 \u0915\u0930\u0947 \u0914\u0930 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0915\u094d\u0930\u093f\u090f\u091f \u0915\u0930\u0947 <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE DATABASE <span style=\"background-color: inherit; font-family: monospace; font-size: inherit;\">DbName<\/span>;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3. UDF Setup<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Download lib_mysqludf_sys.dll From<\/li><li><a href=\"https:\/\/github.com\/selflearntech\/mysql-sys-exec\/blob\/main\/lib_mysqludf_sys.dll\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/selflearntech\/mysql-sys-exec\/blob\/main\/lib_mysqludf_sys.dll<\/a><\/li><li>Copy lib_mysqludf_sys.dll File to C:\\Program Files\\MySQL\\MySQL Server 8.0\\lib\\plugin<\/li><li>Set Path C:\\Program Files\\MySQL\\MySQL Server 8.0\\lib\\plugin<\/li><li>Proper \u0938\u0947\u091f\u0905\u092a \u0939\u094b \u091c\u093e\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u090f\u0915 \u092c\u093e\u0930 \u0938\u093f\u0938\u094d\u091f\u092e \u0915\u094b \u0930\u0940\u0938\u094d\u091f\u093e\u0930\u094d\u091f \u0915\u0930\u0947 \u0914\u0930 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u092f\u0939 \u0915\u092e\u093e\u0902\u0921 Execute \u0915\u0930\u0947 <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DROP FUNCTION IF EXISTS lib_mysqludf_sys_info;\n DROP FUNCTION IF EXISTS sys_get;\n DROP FUNCTION IF EXISTS sys_set;\n DROP FUNCTION IF EXISTS sys_exec;\n DROP FUNCTION IF EXISTS sys_eval;\n CREATE FUNCTION lib_mysqludf_sys_info RETURNS string SONAME 'lib_mysqludf_sys.dll';\n CREATE FUNCTION sys_get RETURNS string SONAME 'lib_mysqludf_sys.dll';\n CREATE FUNCTION sys_set RETURNS int SONAME 'lib_mysqludf_sys.dll';\n CREATE FUNCTION sys_exec RETURNS int SONAME 'lib_mysqludf_sys.dll';\n CREATE FUNCTION sys_eval RETURNS string SONAME 'lib_mysqludf_sys.dll';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u092f\u0939 \u0915\u092e\u093e\u0902\u0921 \u0928\u0939\u0940\u0902 \u091a\u0932 \u0930\u0939\u0940 \u0939\u0948\u0902 \u092f\u093e Error \u0926\u0947 \u0930\u0939\u0940 \u0939\u094b \u0924\u094b \u092a\u094d\u0930\u0949\u092a\u0930 \u0938\u092d\u0940 \u0938\u094d\u091f\u0947\u092a \u091a\u0947\u0915 \u0915\u0930\u0947, \u092f\u0926\u093f UDF \u092b\u093e\u0907\u0932 \u0915\u093e \u092c\u093f\u091f \u091a\u0947\u0902\u091c \u0939\u0941\u0906 \u0924\u094b \u092a\u094d\u0930\u0949\u092c\u094d\u0932\u092e \u0906 \u0938\u0915\u0924\u0940 \u0939\u0948\u0902  <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. cURL Setup <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Download cURL from <a href=\"https:\/\/curl.se\/download.html\" target=\"_blank\" rel=\"noopener\">https:\/\/curl.se\/download.html<\/a><ul><li>\u0907\u0938 \u0935\u0947\u092c\u0938\u093e\u0907\u091f \u092a\u0930 \u0906\u092a\u0915\u094b \u0938\u092d\u0940 \u0911\u092a\u0930\u0947\u091f\u093f\u0902\u0917 \u0938\u093f\u0938\u094d\u091f\u092e \u0915\u0947 \u0939\u093f\u0938\u093e\u092c \u0938\u0947 \u0915\u0930\u094d\u0932 \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u0940 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0928\u0947 \u092a\u0930 \u0906\u092a\u0915\u094b \u090f\u0915 \u092b\u094b\u0932\u094d\u0921\u0930 <strong>curl<\/strong> \u092e\u093f\u0932\u0947\u0917\u093e \u0909\u0938\u0915\u094b \u0906\u092a \u091c\u0939\u093e \u092a\u0930 \u092d\u0940 \u0930\u0916\u0947 \u0909\u0938\u0915\u093e path \u0938\u0947\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 . <\/li><\/ul><\/li><li>Set Path :\\curl\\bin;<\/li><li>Copy three file from [curl\\for system32] to system32<ul><li>Path \u0938\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u0907\u0938 \u092b\u094b\u0932\u094d\u0921\u0930 \u0938\u0947 \u092f\u0939 \u0924\u0940\u0928 \u092b\u093e\u0907\u0932 \u0915\u0949\u092a\u0940 \u0915\u0930\u0915\u0947 \u0938\u093f\u0938\u094d\u091f\u092e 32 \u092b\u094b\u0932\u094d\u0921\u0930 \u092e\u0947\u0902 \u092a\u0947\u0938\u094d\u091f \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940  <\/li><li>Curl.exe<\/li><li>libcurl-4.dll<\/li><li>libcurl.dll.a<\/li><\/ul><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">5. <strong>SQLYog<\/strong> <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 \u091f\u0942\u0932 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0906\u092a \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u091f\u0947\u092c\u0932 \u0914\u0930 \u091f\u094d\u0930\u093f\u0917\u0930 \u0932\u093f\u0916 \u0938\u0915\u0947, \u092f\u0939 \u091f\u0942\u0932 \u091a\u0932\u0928\u0947 \u092e\u0947\u0902 \u0938\u0930\u0932 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u0907\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964<\/li><li>SQL Yog \u0915\u094b \u0932\u0949\u0917\u093f\u0928 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0928\u093f\u091a\u0947 Database Setup \u0915\u0940 \u092a\u094d\u0930\u094b\u0938\u0947\u0938 \u0926\u0940 \u0917\u0908 \u0939\u0948\u0902 \u0909\u0938\u0938\u0947 \u0938\u0947\u091f\u0905\u092a \u0915\u0930\u0947<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">6. Database Setup<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>6.1 \u0939\u092e\u0928\u0947 \u0921\u093e\u091f\u093e\u092c\u0947\u0938 \u092a\u0939\u0932\u0947 \u092c\u0928\u093e \u0932\u093f\u092f\u093e \u0925\u093e, \u0905\u092c \u0909\u0938 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 \u090f\u0915 \u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u0928\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0915\u093e Syntax \u0928\u093f\u091a\u0947 \u0932\u093f\u0916\u093e \u0939\u0948\u0902<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\nUSE <span style=\"background-color: inherit; font-family: monospace; font-size: inherit;\">DbName<\/span>;\n\nCREATE TABLE <span style=\"background-color: inherit; font-family: monospace; font-size: inherit;\">TableName<\/span> (\n<code>id<span style=\"font-family: Menlo, Consolas, monaco, monospace;\"> int(11) NOT NULL AUTO_INCREMENT,<\/span><\/code>t_dt date DEFAULT NULL,\nt_<span style=\"background-color: inherit; font-family: monospace; font-size: inherit;\">tm<\/span><span style=\"background-color: inherit; font-size: inherit;\"> time DEFAULT NULL,<\/span><code><span style=\"font-family: Menlo, Consolas, monaco, monospace; background-color: rgb(255, 255, 255);\">PRIMARY KEY (<\/span><span style=\"background-color: rgba(30, 30, 30, 0.2); font-size: inherit;\">id<\/span><span style=\"font-family: Menlo, Consolas, monaco, monospace;\">)<\/span><\/code>) ;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>6.2 \u091f\u0947\u092c\u0932 \u092c\u0928\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u092a\u0915\u094b \u0909\u0938 \u092a\u0930 \u090f\u0915 Trigger \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u091c\u0948\u0938\u0947 \u0939\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 Row \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b\u0917\u0940 \u0935\u0948\u0938\u0947 \u0939\u0940 Trigger execute \u0939\u094b\u0917\u093e \u0914\u0930 \u091c\u094b \u092d\u0940 \u0905\u092a\u0928\u0947 URL \u0926\u0940 \u0939\u0948\u0902 \u0935\u0939 Call \u0939\u094b \u091c\u093e\u090f\u0917\u0940<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">DELIMITER $$\n drop trigger ins_TableName $$\n CREATE TRIGGER ins_TableName AFTER INSERT ON TableName\n for each row BEGIN\n  declare RetVal int(9);\n  select sys_exec(concat('curl \"http:\/\/yourURL\/page.php', '?id=', new.id, '&amp;date=',new.t_dt, '&amp;time=', new.t_tm, '\"')) into RetVal;\n<span style=\"background-color: inherit; font-family: monospace; font-size: inherit;\">END;<\/span>$$\nDELIMITER ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u092a \u092f\u0939\u093e\u0901 \u092a\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Trigger \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0905\u092d\u0940 \u0939\u092e\u0947\u0902 \u0915\u0947\u0935\u0932 \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u092a\u0930 Trigger \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u092f\u0926\u093f \u0906\u092a Update \u0914\u0930 Delete \u092a\u0930 \u092d\u0940 Trigger \u0932\u093f\u0916\u0928\u093e \u091a\u093e\u0939\u0947 \u0924\u094b \u0932\u093f\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Send HTTP request from MySQL trigger<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0909\u0926\u0939\u093e\u0930\u0923 \u0938\u0947 \u0906\u092a MySQL Trigger \u0938\u0947 PHP \u0938\u0930\u094d\u0935\u0930 \u092a\u0930 Request Send \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0927\u094d\u092f\u093e\u0928 \u0926\u0947\u0928\u0947 \u092f\u094b\u0917\u094d\u092f<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u092f\u0926\u093f \u0915\u0939\u0940 \u092a\u0930 \u092d\u0940 \u0938\u092e\u0938\u094d\u092f\u093e \u0906 \u0930\u0939\u0940 \u0939\u0948\u0902 \u0924\u094b \u090f\u0915 \u090f\u0915 \u0938\u094d\u091f\u0947\u092a \u0915\u094b \u092a\u094d\u0930\u0949\u092a\u0930 \u091a\u0947\u0915 \u0915\u0930\u0947<\/li><li>\u092f\u0926\u093f \u0906\u092a\u0915\u0947 PC \u0915\u093e \u0911\u092a\u0930\u0947\u091f\u093f\u0902\u0917 \u0938\u093f\u0938\u094d\u091f\u092e \u0915\u0947 \u092c\u093f\u091f \u0914\u0930 lib_mysqludf_sys.dll \u0915\u0947 \u092c\u093f\u091f \u092e\u0947\u0902 \u0905\u0902\u0924\u0930 \u0939\u0941\u0906 \u0924\u094b \u092d\u0940 \u092f\u0939 \u092b\u093e\u0907\u0932 \u0915\u093e\u0930\u094d\u092f \u0928\u0939\u0940\u0902 \u0915\u0930\u0924\u0940<\/li><li>\u0939\u092e\u0928\u0947 \u092a\u0942\u0930\u093e \u0938\u0947\u091f\u0905\u092a 64Bit \u0915\u0947 \u0939\u093f\u0938\u093e\u092c \u0938\u0947 \u0915\u093f\u092f\u093e \u0939\u0948\u0902<\/li><li>\u0915\u094b\u0908 \u092d\u0940 \u0907\u0902\u0938\u094d\u091f\u093e\u0932\u0947\u0936\u0928 \u0915\u0947 \u092c\u093e\u0926 PC \u0915\u094b \u0930\u0940\u0938\u094d\u091f\u093e\u0930\u094d\u091f \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0915\u092d\u0940 \u0915\u092d\u0940 \u0930\u0940\u0938\u094d\u091f\u093e\u0930\u094d\u091f \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u0940 \u092b\u093e\u0907\u0932 Execution \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-installation\/\">MySQL Installation \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a> <\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-tutorial-basic-n-advance\/\">Basic MySQL<\/a> <\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/go-language-in-hindi\/\">Go Language (Golang) : \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 \u0938\u0902\u0915\u094d\u0937\u093f\u092a\u094d\u0924 \u091c\u093e\u0928\u0915\u093e\u0930\u0940<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/shared-hosting-and-domain\/\">\u091c\u093e\u0928\u0947 SHARED HOSTING, DOMAIN \u0914\u0930 HOSTING \u0915\u0947 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902<\/a><\/li><\/ul>\n\n\n\n<p>\u092f\u0926\u093f Trigger \u0932\u093f\u0916\u0928\u0947 \u092e\u0947\u0902 \u0915\u094b\u0908 \u0938\u092e\u0938\u094d\u092f\u093e \u0906\u092f\u0947 \u0924\u094b \u0906\u092a Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Sys_exec \u0915\u094b Example \u0938\u0947 \u0938\u092e\u091d\u093e\u090f \u091c\u093f\u0938 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0939\u094b\u0928\u0947 \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u090f\u0915 \u091f\u094d\u0930\u093f\u0917\u0930 \u0932\u093f\u0916\u0928\u093e \u0939\u094b\u0917\u093e \u091f\u094d\u0930\u093f\u0917\u0930 \u0938\u0947 \u090f\u0915 sys_exec \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0915\u0949\u0932 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0939\u092e sys_exec \u092b\u0902\u0915\u094d\u0936\u0928 \u0938\u0947 cURL \u0915\u093e Use \u0915\u0930\u0915\u0947 \u0939\u092e URL \u0915\u0949\u0932 \u0915\u0930 \u0926\u0947\u0902\u0917\u0947 Sys_exec on Shared Server Shared Server \u092a\u0930 \u0915\u093e\u0930\u094d\u092f \u0928\u0939\u0940\u0902 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":770,"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-750","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\/03\/mysql-sys-exec.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/750","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=750"}],"version-history":[{"count":24,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/750\/revisions"}],"predecessor-version":[{"id":1940,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/750\/revisions\/1940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/770"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}