{"id":3682,"date":"2021-12-13T11:24:33","date_gmt":"2021-12-13T11:24:33","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3682"},"modified":"2021-12-13T11:24:33","modified_gmt":"2021-12-13T11:24:33","slug":"how-can-i-add-procedures-and-triggers-to-my-mysql-database","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/","title":{"rendered":"How can I add procedures and triggers to my MySQL database?"},"content":{"rendered":"<div><span class=\"Apple-style-span\">From their Java applications, as more and more clients want to use advanced SQL features,<\/span><\/div>\n<p><span class=\"Apple-style-span\">we are running MySQL version 5.1.x or higher where user can run CREATE PROCEDURE and CREATE TRIGGER statements.<\/span><\/p>\n<div>Just ensure when assigning database user to a database, you should check ROUTINE and TRIGGER related privileges or ALL privileges .<\/div>\n<div><\/div>\n<div>for more read on the statements in MySQL documentation:<\/div>\n<div>\n<div><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/create-procedure.html\">CREATE PROCEDURE<\/a>\u00a0Syntax<\/div>\n<\/div>\n<div><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/create-trigger.html\">CREATE TRIGGER<\/a>\u00a0Syntax<\/div>\n<div>Using command line &#8216;mysql&#8217; client or any other client, you can create procedures.<\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>From their Java applications, as more and more clients want to use advanced SQL features, we are running MySQL version 5.1.x or higher where user can run CREATE PROCEDURE and CREATE TRIGGER statements. Just ensure when assigning database user to a database, you should check ROUTINE and TRIGGER related privileges or ALL privileges . for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3682","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can I add procedures and triggers to my MySQL database? - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I add procedures and triggers to my MySQL database? - OWS KB\" \/>\n<meta property=\"og:description\" content=\"From their Java applications, as more and more clients want to use advanced SQL features, we are running MySQL version 5.1.x or higher where user can run CREATE PROCEDURE and CREATE TRIGGER statements. Just ensure when assigning database user to a database, you should check ROUTINE and TRIGGER related privileges or ALL privileges . for [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-13T11:24:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"0 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\",\"name\":\"How can I add procedures and triggers to my MySQL database? - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"datePublished\":\"2021-12-13T11:24:33+00:00\",\"dateModified\":\"2021-12-13T11:24:33+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-can-i-add-procedures-and-triggers-to-my-mysql-database\/\",\"name\":\"How can I add procedures and triggers to my MySQL database?\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3682"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3682\/revisions"}],"predecessor-version":[{"id":3683,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3682\/revisions\/3683"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}