{"id":437,"date":"2025-03-27T01:37:57","date_gmt":"2025-03-26T22:37:57","guid":{"rendered":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437"},"modified":"2025-03-27T01:40:04","modified_gmt":"2025-03-26T22:40:04","slug":"sql-triggers","status":"publish","type":"page","link":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437","title":{"rendered":"SQL triggers"},"content":{"rendered":"\n<p><strong>Creating tables<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCreate table linnad(\nlinnID intAuto_increment PRIMARYKEY,\nlinnanimi varchar(15),\nrahvaarv int);\n\nCreate table logi(\nid intAuto_increment PRIMARYKEY,\naeg DATETIME,\ntoiming\u00a0 varchar(100),\nandmed varchar(200)\n)\n<\/pre><\/div>\n\n\n<p><strong>Creating an add trigger<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" width=\"630\" height=\"678\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png\" alt=\"\" class=\"wp-image-439 lazyload\" style=\"--smush-placeholder-width: 630px; --smush-placeholder-aspect-ratio: 630\/678;width:630px;height:auto\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png 630w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3-279x300.png 279w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3-139x150.png 139w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3-200x215.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3-600x646.png 600w\" data-sizes=\"(max-width: 630px) 100vw, 630px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/><\/figure>\n\n\n\n<p>Adding data and checking the trigger<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"498\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4.png\" alt=\"\" class=\"wp-image-440 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4.png 1024w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4-300x146.png 300w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4-768x374.png 768w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4-150x73.png 150w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4-200x97.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-4-600x292.png 600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/498;\" \/><\/figure>\n\n\n\n<p>Creating a deletion trigger<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"623\" height=\"664\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5.png\" alt=\"\" class=\"wp-image-441 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5.png 623w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5-281x300.png 281w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5-141x150.png 141w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5-200x213.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-5-600x639.png 600w\" data-sizes=\"(max-width: 623px) 100vw, 623px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 623px; --smush-placeholder-aspect-ratio: 623\/664;\" \/><\/figure>\n\n\n\n<p>trigger check<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"541\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6.png\" alt=\"\" class=\"wp-image-442 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6.png 1024w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6-300x158.png 300w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6-768x406.png 768w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6-150x79.png 150w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6-200x106.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-6-600x317.png 600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/541;\" \/><\/figure>\n\n\n\n<p>Creating an update trigger<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"617\" height=\"668\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7.png\" alt=\"\" class=\"wp-image-443 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7.png 617w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7-277x300.png 277w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7-139x150.png 139w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7-200x217.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-7-600x650.png 600w\" data-sizes=\"(max-width: 617px) 100vw, 617px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 617px; --smush-placeholder-aspect-ratio: 617\/668;\" \/><\/figure>\n\n\n\n<p>Functional check<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"236\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8.png\" alt=\"\" class=\"wp-image-444 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8.png 1024w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8-300x69.png 300w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8-768x177.png 768w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8-150x35.png 150w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8-200x46.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-8-600x138.png 600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/236;\" \/><\/figure>\n\n\n\n<p>Creating two new tables<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCreatetablelogitabel(\nid intAuto_increment PRIMARYKEY,\naeg DATETIME,toiming\u00a0 varchar(100),\nAUTOandmed varchar(200)\n);\n\nCreatetableAuto(\nAutoID intAuto_increment PRIMARYKEY,\nautonumber varchar(6),\nmark varchar(20),\nmudel varchar(20),\nomanik varchar(50)\n);\n<\/pre><\/div>\n\n\n<p>Trigger for deletion<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"639\" height=\"683\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9.png\" alt=\"\" class=\"wp-image-445 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9.png 639w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9-281x300.png 281w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9-140x150.png 140w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9-200x214.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-9-600x641.png 600w\" data-sizes=\"(max-width: 639px) 100vw, 639px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 639px; --smush-placeholder-aspect-ratio: 639\/683;\" \/><\/figure>\n\n\n\n<p>Creation trigger<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"616\" height=\"660\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10.png\" alt=\"\" class=\"wp-image-446 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10.png 616w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10-280x300.png 280w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10-140x150.png 140w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10-200x214.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-10-600x643.png 600w\" data-sizes=\"(max-width: 616px) 100vw, 616px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 616px; --smush-placeholder-aspect-ratio: 616\/660;\" \/><\/figure>\n\n\n\n<p>Trigger for update<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"603\" height=\"685\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11.png\" alt=\"\" class=\"wp-image-447 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11.png 603w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11-264x300.png 264w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11-132x150.png 132w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11-200x227.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-11-600x682.png 600w\" data-sizes=\"(max-width: 603px) 100vw, 603px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 603px; --smush-placeholder-aspect-ratio: 603\/685;\" \/><\/figure>\n\n\n\n<p>Displaying logs<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"945\" height=\"136\" data-src=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12.png\" alt=\"\" class=\"wp-image-448 lazyload\" data-srcset=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12.png 945w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12-300x43.png 300w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12-768x111.png 768w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12-150x22.png 150w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12-200x29.png 200w, https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-12-600x86.png 600w\" data-sizes=\"(max-width: 945px) 100vw, 945px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 945px; --smush-placeholder-aspect-ratio: 945\/136;\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Creating tables Creating an add trigger Adding data and checking the trigger Creating a deletion trigger trigger check Creating an update trigger Functional check Creating two new tables Trigger for deletion Creation trigger Trigger for update Displaying logs<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"saved_in_kubio":false,"footnotes":""},"class_list":["post-437","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL triggers - Deniel Kruusman Portfolio<\/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:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL triggers - Deniel Kruusman Portfolio\" \/>\n<meta property=\"og:description\" content=\"Creating tables Creating an add trigger Adding data and checking the trigger Creating a deletion trigger trigger check Creating an update trigger Functional check Creating two new tables Trigger for deletion Creation trigger Trigger for update Displaying logs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437\" \/>\n<meta property=\"og:site_name\" content=\"Deniel Kruusman Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-26T22:40:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"630\" \/>\n\t<meta property=\"og:image:height\" content=\"678\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437\",\"url\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437\",\"name\":\"SQL triggers - Deniel Kruusman Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/image-3.png\",\"datePublished\":\"2025-03-26T22:37:57+00:00\",\"dateModified\":\"2025-03-26T22:40:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437#primaryimage\",\"url\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/image-3.png\",\"contentUrl\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/image-3.png\",\"width\":630,\"height\":678},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?page_id=437#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL triggers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Deniel Kruusman Portfolio\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/denielkruusman24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL triggers - Deniel Kruusman Portfolio","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:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437","og_locale":"en_US","og_type":"article","og_title":"SQL triggers - Deniel Kruusman Portfolio","og_description":"Creating tables Creating an add trigger Adding data and checking the trigger Creating a deletion trigger trigger check Creating an update trigger Functional check Creating two new tables Trigger for deletion Creation trigger Trigger for update Displaying logs","og_url":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437","og_site_name":"Deniel Kruusman Portfolio","article_modified_time":"2025-03-26T22:40:04+00:00","og_image":[{"width":630,"height":678,"url":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437","url":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437","name":"SQL triggers - Deniel Kruusman Portfolio","isPartOf":{"@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437#primaryimage"},"image":{"@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437#primaryimage"},"thumbnailUrl":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png","datePublished":"2025-03-26T22:37:57+00:00","dateModified":"2025-03-26T22:40:04+00:00","breadcrumb":{"@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437#primaryimage","url":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png","contentUrl":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/2\/2025\/03\/image-3.png","width":630,"height":678},{"@type":"BreadcrumbList","@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?page_id=437#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SQL triggers"}]},{"@type":"WebSite","@id":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/","name":"Deniel Kruusman Portfolio","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"kubio_ai_page_context":{"short_desc":"","purpose":"general"},"_links":{"self":[{"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/pages\/437","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=437"}],"version-history":[{"count":1,"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/pages\/437\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=\/wp\/v2\/pages\/437\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/denielkruusman24.thkit.ee\/wp\/eng\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}