{"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"],"_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}]}}