{"id":2576,"date":"2020-02-04T12:19:54","date_gmt":"2020-02-04T11:19:54","guid":{"rendered":"https:\/\/vielhuber.de\/?p=2576"},"modified":"2020-02-04T12:22:57","modified_gmt":"2020-02-04T11:22:57","slug":"mysql-trigger-editieren","status":"publish","type":"post","link":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/","title":{"rendered":"MySQL-Trigger editieren"},"content":{"rendered":"\n<p><a rel=\"noreferrer noopener\" aria-label=\"MySQL (opens in a new tab)\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/trigger-syntax.html\" target=\"_blank\">MySQL<\/a> bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren. Das CREATE TRIGGER Statement l\u00e4sst sich indirekt \u00fcber das <a rel=\"noreferrer noopener\" aria-label=\"information_schema (opens in a new tab)\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/information-schema.html\" target=\"_blank\">information_schema<\/a> auslesen. Damit k\u00f6nnen wir \u00fcber einen Umweg Triggers \u00e4ndern. Dazu nimmt man im Ergebnis des folgenden SELECT-Befehls (vorher Datenbank- und Triggername \u00e4ndern) seine \u00c4nderungen vor und f\u00fchrt das Query aus.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"githubgist\" data-gist-file=\"update.sql\">734f80792453bf24a6d7b04f78949529<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren. Das CREATE TRIGGER Statement l\u00e4sst sich indirekt \u00fcber das information_schema auslesen. Damit k\u00f6nnen wir \u00fcber einen Umweg Triggers \u00e4ndern. Dazu nimmt man im Ergebnis des folgenden SELECT-Befehls (vorher Datenbank- und Triggername \u00e4ndern) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"gtbabel_prevent_lngs":"","gtbabel_alt_lng":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-2576","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-blog"},"acf":[],"yoast_head":"<title>MySQL-Trigger editieren &#060; Vielhuber David<\/title>\n<meta name=\"description\" content=\"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generi...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL-Trigger editieren &#060; Vielhuber David\" \/>\n<meta property=\"og:description\" content=\"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/\" \/>\n<meta property=\"og:site_name\" content=\"Vielhuber David\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-04T11:19:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-04T11:22:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"552\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"David\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vielhuber\" \/>\n<meta name=\"twitter:site\" content=\"@vielhuber\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"David\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/\"},\"author\":{\"name\":\"David\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#\\\/schema\\\/person\\\/64d4ff14713d413ea4d9b210d0c2c6ef\"},\"headline\":\"MySQL-Trigger editieren\",\"datePublished\":\"2020-02-04T11:19:54+00:00\",\"dateModified\":\"2020-02-04T11:22:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/\"},\"wordCount\":77,\"publisher\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#\\\/schema\\\/person\\\/64d4ff14713d413ea4d9b210d0c2c6ef\"},\"articleSection\":[\"Blog\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/\",\"url\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/\",\"name\":\"MySQL-Trigger editieren &#060; Vielhuber David\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#website\"},\"datePublished\":\"2020-02-04T11:19:54+00:00\",\"dateModified\":\"2020-02-04T11:22:57+00:00\",\"description\":\"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/blog\\\/mysql-trigger-editieren\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/vielhuber.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL-Trigger editieren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#website\",\"url\":\"https:\\\/\\\/vielhuber.de\\\/\",\"name\":\"Vielhuber David\",\"description\":\"Full-Stack Developer\",\"publisher\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#\\\/schema\\\/person\\\/64d4ff14713d413ea4d9b210d0c2c6ef\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vielhuber.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/vielhuber.de\\\/#\\\/schema\\\/person\\\/64d4ff14713d413ea4d9b210d0c2c6ef\",\"name\":\"David\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/vielhuber.de\\\/wp-content\\\/uploads\\\/about.jpg\",\"url\":\"https:\\\/\\\/vielhuber.de\\\/wp-content\\\/uploads\\\/about.jpg\",\"contentUrl\":\"https:\\\/\\\/vielhuber.de\\\/wp-content\\\/uploads\\\/about.jpg\",\"width\":700,\"height\":552,\"caption\":\"David\"},\"logo\":{\"@id\":\"https:\\\/\\\/vielhuber.de\\\/wp-content\\\/uploads\\\/about.jpg\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/vielhuber\"]}]}<\/script>","yoast_head_json":{"title":"MySQL-Trigger editieren &#060; Vielhuber David","description":"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generi...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/","og_locale":"de_DE","og_type":"article","og_title":"MySQL-Trigger editieren &#060; Vielhuber David","og_description":"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren.","og_url":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/","og_site_name":"Vielhuber David","article_published_time":"2020-02-04T11:19:54+00:00","article_modified_time":"2020-02-04T11:22:57+00:00","og_image":[{"width":700,"height":552,"url":"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg","type":"image\/jpeg"}],"author":"David","twitter_card":"summary_large_image","twitter_creator":"@vielhuber","twitter_site":"@vielhuber","twitter_misc":{"Verfasst von":"David"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/#article","isPartOf":{"@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/"},"author":{"name":"David","@id":"https:\/\/vielhuber.de\/#\/schema\/person\/64d4ff14713d413ea4d9b210d0c2c6ef"},"headline":"MySQL-Trigger editieren","datePublished":"2020-02-04T11:19:54+00:00","dateModified":"2020-02-04T11:22:57+00:00","mainEntityOfPage":{"@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/"},"wordCount":77,"publisher":{"@id":"https:\/\/vielhuber.de\/#\/schema\/person\/64d4ff14713d413ea4d9b210d0c2c6ef"},"articleSection":["Blog"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/","url":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/","name":"MySQL-Trigger editieren &#060; Vielhuber David","isPartOf":{"@id":"https:\/\/vielhuber.de\/#website"},"datePublished":"2020-02-04T11:19:54+00:00","dateModified":"2020-02-04T11:22:57+00:00","description":"MySQL bietet leider keine Funktion ALTER TRIGGER an. Um einen bestehenden Trigger zu editieren, muss man diesen zun\u00e4chst l\u00f6schen und dann neu generieren.","breadcrumb":{"@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vielhuber.de\/blog\/mysql-trigger-editieren\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vielhuber.de\/"},{"@type":"ListItem","position":2,"name":"MySQL-Trigger editieren"}]},{"@type":"WebSite","@id":"https:\/\/vielhuber.de\/#website","url":"https:\/\/vielhuber.de\/","name":"Vielhuber David","description":"Full-Stack Developer","publisher":{"@id":"https:\/\/vielhuber.de\/#\/schema\/person\/64d4ff14713d413ea4d9b210d0c2c6ef"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vielhuber.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/vielhuber.de\/#\/schema\/person\/64d4ff14713d413ea4d9b210d0c2c6ef","name":"David","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg","url":"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg","contentUrl":"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg","width":700,"height":552,"caption":"David"},"logo":{"@id":"https:\/\/vielhuber.de\/wp-content\/uploads\/about.jpg"},"sameAs":["https:\/\/x.com\/vielhuber"]}]}},"_links":{"self":[{"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/posts\/2576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/comments?post=2576"}],"version-history":[{"count":5,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/posts\/2576\/revisions"}],"predecessor-version":[{"id":2582,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/posts\/2576\/revisions\/2582"}],"wp:attachment":[{"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/media?parent=2576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/categories?post=2576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vielhuber.de\/ru\/wp-json\/wp\/v2\/tags?post=2576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}