{"id":3396,"date":"2025-03-19T06:46:10","date_gmt":"2025-03-19T06:46:10","guid":{"rendered":"https:\/\/mariasmolina24.thkit.ee\/wp\/?page_id=3396"},"modified":"2025-03-23T21:36:34","modified_gmt":"2025-03-23T18:36:34","slug":"sql-triggerite-loomine","status":"publish","type":"page","link":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/","title":{"rendered":"SQL: Creating Triggers"},"content":{"rendered":"\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-db267217e631b96621ca2f10fd6dfc82\">SQL triggerid on spetsiaalsed andmebaasi objektid, mis k\u00e4ivituvad automaatselt, kui toimub teatud s\u00fcndmus (nt INSERT, UPDATE v\u00f5i DELETE). <strong>SQL Triggerite loomine<\/strong> aitab automatiseerida protsesse, tagada andmete terviklikkust ja rakendada \u00e4ri loogikat otse andmebaasis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\"><strong>SQL Server<\/strong><\/a><\/h2>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Loome andmebaasi ja kaks tabelit<\/strong><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCreate database trigerTARgv24;\nUSE trigerTARgv24;\nCreate table linnad(\nlinnID int PRIMARY KEY IDENTITY (1,1),\nlinnanimi varchar(15) NOT NULL,\nrahvaarv int);\n\nCreate table logi(\nid int PRIMARY KEY IDENTITY (1,1),\naeg DATETIME,\ntoiming  varchar(100),\nandmed TEXT\n)\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong><strong>Trigger lisatud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211;<strong> INSERT<\/strong><\/strong><\/h3>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-f887821d85a434c8ba03d0ff5f456160\">J\u00e4lgib andmete sisestamine tabelis linnad ja teeb vastava kirje tabelis logi<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TRIGGER linnaLisamine\nON linnad --tabelinimi, mis on vaja j\u00e4lgida\nFOR INSERT\nAS\nINSERT INTO logi(aeg, toiming, andmed)\nSELECT\nGETDATE(),  --aeg\n&#039;on tehtud INSERT k\u00e4sk&#039;,  --toiming\ninserted.linnanimi  --andmed\nFROM inserted;\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Trigeri tegevuse kontroll<\/strong><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO linnad(linnanimi, rahvaarv)\nVALUES (&#039;Tallinn&#039;, 600000);\nSELECT * FROM linnad;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"505\" height=\"294\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png\" alt=\"SQL Triggerite loomine\" class=\"wp-image-3402\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png 505w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144-300x175.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144-150x87.png 150w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-72f12cdc11de033cc857cc523bf1385d\">\n<li><strong>SQL Triggeri Uuendamine<\/strong> (Muutmine)\n<ul class=\"wp-block-list\">\n<li>Leiame vajaliku tabeli andmebaasis<\/li>\n\n\n\n<li>Avame <strong>Triggers<\/strong> kausta<\/li>\n\n\n\n<li>Paremkl\u00f5psame soovitud triggeril<\/li>\n\n\n\n<li>Valime <strong>Modify<\/strong> (Muuda).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"207\" height=\"287\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-145.png\" alt=\"\" class=\"wp-image-3404\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-145.png 207w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-145-108x150.png 108w\" sizes=\"auto, (max-width: 207px) 100vw, 207px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"259\" height=\"291\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-146.png\" alt=\"\" class=\"wp-image-3405\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-146.png 259w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-146-134x150.png 134w\" sizes=\"auto, (max-width: 259px) 100vw, 259px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-6681be664592899c4095be6705d9dcc4\">See avab dialoogiboksi, kus me saame teha vajalikud muudatused ja salvestada need.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUSE &#x5B;trigerTARgv24]\nGO\n\/****** Object:  Trigger &#x5B;dbo].&#x5B;linnaLisamine]    Script Date: 19.03.2025 09:04:08 ******\/\nSET ANSI_NULLS ON\nGO\nSET QUOTED_IDENTIFIER ON\nGO\nALTER TRIGGER &#x5B;dbo].&#x5B;linnaLisamine]\nON &#x5B;dbo].&#x5B;linnad] --tabelinimi, mis on vaja j\u00e4lgida\nFOR INSERT\nAS\nINSERT INTO logi(aeg, toiming, andmed)\nSELECT\nGETDATE(),  --aeg\n&#039;on tehtud INSERT k\u00e4sk&#039;,  --toiming\nCONCAT(&#039;linn: &#039;, inserted.linnanimi, &#039;, elanike arv: &#039;, inserted.rahvaarv)  --andmed\nFROM inserted;\n<\/pre><\/div>\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-3f4217c8fd071637ddec982fff64d227\">T\u00f5sta esile <strong>ALTER TRIGGER<\/strong> &#8211;&gt; <strong>Execute<\/strong> &#8211;&gt; <strong>K\u00e4sk t\u00e4idetud<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1004\" height=\"593\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147.png\" alt=\"SQL Triggerite loomine\" class=\"wp-image-3407\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147.png 1004w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147-300x177.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147-768x454.png 768w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147-150x89.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-147-600x354.png 600w\" sizes=\"auto, (max-width: 1004px) 100vw, 1004px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-e88399797167c82e03a614d9a039ae40\">Andmete sisestamine tabelisse <strong>&#8220;logi&#8221;<\/strong> on muutunud.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"324\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-148.png\" alt=\"SQL Triggerite loomine\" class=\"wp-image-3409\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-148.png 528w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-148-300x184.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-148-150x92.png 150w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-91481a3089b5dfa74ffc27d960b12ded\">Tools &#8211;&gt; Options &#8211;&gt; Designers &#8211;&gt; Table and Database Designers &#8211;&gt; Eemaldada linnuke valikust <strong>&#8220;Prevent saving changes that require table re-creation&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"440\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-149.png\" alt=\"\" class=\"wp-image-3416\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-149.png 751w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-149-300x176.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-149-150x88.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-149-600x352.png 600w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"329\" height=\"298\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-150.png\" alt=\"\" class=\"wp-image-3418\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-150.png 329w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-150-300x272.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-150-150x136.png 150w\" sizes=\"auto, (max-width: 329px) 100vw, 329px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-6c40292068e1a5b69f1706b1ebf1e213\">Lisame v\u00e4lja <strong>&#8220;kasutaja&#8221;<\/strong> tabelisse ja salvestame.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"185\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-151.png\" alt=\"\" class=\"wp-image-3420\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-151.png 396w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-151-300x140.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-151-150x70.png 150w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-c8d9285722c625e936111648c10f42b2\">Muudame triggeri.<br><strong>SUSER_NAME<\/strong> on SQL funktsioon, mis tagastab hetkel sisse logitud kasutaja nime.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TRIGGER &#x5B;dbo].&#x5B;linnaLisamine]\nON &#x5B;dbo].&#x5B;linnad] --tabelinimi, mis on vaja j\u00e4lgida\nFOR INSERT\nAS\nINSERT INTO logi(kasutaja, aeg, toiming, andmed)\nSELECT\nSUSER_NAME(), --USER\nGETDATE(),  --aeg\n&#039;on tehtud INSERT k\u00e4sk&#039;,  --toiming\nCONCAT(&#039;linn: &#039;, inserted.linnanimi, &#039;, elanike arv: &#039;, inserted.rahvaarv)  --andmed\nFROM inserted;\n<\/pre><\/div>\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-fe14e18eef35ebb074d31a00f1c0d220\"><strong>Kontrollime:<\/strong> Lisab kasutaja, kes andmed tabelisse sisestas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"589\" height=\"386\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-152.png\" alt=\"\" class=\"wp-image-3423\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-152.png 589w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-152-300x197.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-152-150x98.png 150w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong><strong>Trigger eemaldatud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211; <strong>DELETE<\/strong><\/strong><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TRIGGER linnaKustutamine\nON linnad --tabelinimi, mis on vaja j\u00e4lgida\nFOR DELETE\nAS\nINSERT INTO logi(kasutaja, aeg, toiming, andmed)\nSELECT\nSUSER_NAME(), --USER\nGETDATE(),  --aeg\n&#039;on tehtud DELETE k\u00e4sk&#039;,  --toiming\nCONCAT(&#039;linn: &#039;, deleted.linnanimi, &#039;, elanike arv: &#039;, deleted.rahvaarv)  --andmed\nFROM deleted;\n<\/pre><\/div>\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-8bd8a7e5f9200b5fa03de1482f85e433\">Kontrollimine<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--kontroll\nDELETE FROM linnad\nWHERE linnID=1;\nSELECT * FROM linnad;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"596\" height=\"358\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-153.png\" alt=\"\" class=\"wp-image-3431\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-153.png 596w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-153-300x180.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-153-150x90.png 150w\" sizes=\"auto, (max-width: 596px) 100vw, 596px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center has-colibri-color-6-color has-text-color has-link-color wp-elements-f83d73761ec117158eb661777d08133f\"><strong><strong>Trigger muudetud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211; <strong>UPDATE<\/strong><\/strong><\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TRIGGER linnaUuendamine\nON linnad --tabelinimi, mis on vaja j\u00e4lgida\nFOR UPDATE\nAS\nINSERT INTO logi(kasutaja, aeg, toiming, andmed)\nSELECT\nSUSER_NAME(), \nGETDATE(),  \n&#039;on tehtud UPDATE k\u00e4sk&#039;,  \nCONCAT(&#039;vanad andmed -linn: &#039;, deleted.linnanimi,\n&#039;, elanike arv: &#039;, deleted.rahvaarv,\n&#039;uued andmed -linn: &#039;, inserted.linnanimi,\n&#039;, elanike arv: &#039;, inserted.rahvaarv)  \nFROM deleted\nINNER JOIN inserted\nON deleted.linnID=inserted.linnID;\n<\/pre><\/div>\n\n\n<p class=\"has-text-align-center has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-8bd8a7e5f9200b5fa03de1482f85e433\">Kontrollimine<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"882\" height=\"391\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154.png\" alt=\"\" class=\"wp-image-3444\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154.png 882w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154-300x133.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154-768x340.png 768w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154-150x66.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-154-600x266.png 600w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center\"><strong>XAMPP<\/strong><\/h2>\n\n\n\n<p class=\"has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-72dd1ac762d37536d92a1ea3fd3ec17d\"><strong>Loome trigger&#8217;eid<\/strong> XAMPP-is (mis kasutab MySQL v\u00f5i MariaDB andmebaasi) j\u00e4rgides j\u00e4rgmisi samme. N\u00e4iteks <strong>teeme SQL triggeri<\/strong>, mis logib iga linnade lisamise v\u00f5i kustutamise andmed.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCreate table linnad(\nlinnID int Auto_increment PRIMARY KEY,\nlinnanimi varchar(15),\nrahvaarv int);\n\nCreate table logi(\nid int Auto_increment PRIMARY KEY,\naeg DATETIME,\ntoiming  varchar(100),\nandmed TEXT,\nkasutaja varchar(50)\n)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"699\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-155.png\" alt=\"\" class=\"wp-image-3452\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-155.png 457w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-155-196x300.png 196w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-155-98x150.png 98w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/><figcaption class=\"wp-element-caption\">P\u00e4\u00e4stikud<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Trigger lisatud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211;<strong> INSERT<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"656\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161.png\" alt=\"SQL Triggerite loomine\" class=\"wp-image-3462\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161.png 650w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161-297x300.png 297w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161-150x150.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161-600x606.png 600w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-161-100x100.png 100w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p class=\"has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-1a4cf5caf9167342676274b288860b1b\">\u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Linnad \u0438 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Logi<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;69db0c5a2b58b&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"69db0c5a2b58b\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1038\" height=\"92\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162.png\" alt=\"\" class=\"wp-image-3464\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162.png 1038w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162-300x27.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162-1024x91.png 1024w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162-768x68.png 768w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162-150x13.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-162-600x53.png 600w\" sizes=\"auto, (max-width: 1038px) 100vw, 1038px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Trigger muudetud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211; <strong>UPDATE<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"645\" height=\"727\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-169.png\" alt=\"SQL Triggerite loomine\" class=\"wp-image-3479\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-169.png 645w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-169-266x300.png 266w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-169-133x150.png 133w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-169-600x676.png 600w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/figure>\n\n\n\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1149\" height=\"165\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166.png\" alt=\"\" class=\"wp-image-3474\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166.png 1149w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166-300x43.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166-1024x147.png 1024w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166-768x110.png 768w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166-150x22.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-166-600x86.png 600w\" sizes=\"auto, (max-width: 1149px) 100vw, 1149px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Trigger eemaldatud kirjeid j\u00e4lgimiseks tabelis &#8220;linnad&#8221;<\/strong> &#8211; <strong>DELETE<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"653\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-171.png\" alt=\"\" class=\"wp-image-3484\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-171.png 620w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-171-285x300.png 285w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-171-142x150.png 142w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-171-600x632.png 600w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1175\" height=\"42\" src=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170.png\" alt=\"\" class=\"wp-image-3481\" srcset=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170.png 1175w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170-300x11.png 300w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170-1024x37.png 1024w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170-768x27.png 768w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170-150x5.png 150w, https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-170-600x21.png 600w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity is-style-wide\" \/>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Kombineerime INSERT ja DELETE triggerid<\/strong><\/h3>\n\n\n\n<p class=\"has-colibri-color-6-color has-colibri-color-5-background-color has-text-color has-background has-link-color has-medium-font-size wp-elements-d2c91f7a536d909538a6ba28cb4ad063\">See SQL <strong>trigger<\/strong> <strong>linnaLisamineJaKustutamine<\/strong> salvestab logi iga kord, kui linnade tabelis lisatakse uus linn v\u00f5i kustutatakse olemasolev linn. Trigger k\u00e4ivitub p\u00e4rast <strong>INSERT<\/strong> v\u00f5i <strong>DELETE<\/strong> toimingut ja salvestab logisse andmed.<br><strong><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-triggers\/sql-server-create-trigger\/\"><mark style=\"color:#008ee3\" class=\"has-inline-color\">Kood on tehtud selle allika baasil.<\/mark><\/a><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TRIGGER linnaLisamineJaKustutamine\nON linnad \nAFTER INSERT, DELETE\nAS\nBEGIN\n\tSET NOCOUNT ON;\n\tINSERT INTO logi(kasutaja, aeg, toiming, andmed)\n\tSELECT\n\tSUSER_NAME(),\n\tGETDATE(),  \n\t&#039;INSERT&#039;,  \n\tCONCAT(&#039;linn: &#039;, inserted.linnanimi,\n\t&#039;, elanike arv: &#039;, inserted.rahvaarv)  \n\tFROM inserted\n\n\tUNION ALL\n\n\tSELECT\n\tSUSER_NAME(),\n\tGETDATE(),  \n\t&#039;DELETE&#039;, \n\tCONCAT(&#039;linn: &#039;, deleted.linnanimi,\n\t&#039;, elanike arv: &#039;, deleted.rahvaarv)  \n\tFROM deleted;\nEND\n\n--L\u00e4bivaatus\nINSERT INTO linnad(linnanimi, rahvaarv)\nVALUES (&#039;Tartu&#039;, 50000);\n\nDELETE FROM \n    linnad\nWHERE \n    linnID=2;\nSELECT * FROM linnad;\nSELECT * FROM logi;\n\n--Diaktiveerib p\u00e4\u00e4stiku\nDISABLE TRIGGER linnaLisamine\nON linnad\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>SQL triggerid on spetsiaalsed andmebaasi objektid, mis k\u00e4ivituvad automaatselt, kui toimub teatud s\u00fcndmus [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3396","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine<\/title>\n<meta name=\"description\" content=\"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger&#039;eid efektiivseks andmehalduseks\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine\" \/>\n<meta property=\"og:description\" content=\"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger&#039;eid efektiivseks andmehalduseks\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Smolina STUDY Portfolio | ENG |\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-23T18:36:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png\" \/>\n\t<meta property=\"og:image:width\" content=\"505\" \/>\n\t<meta property=\"og:image:height\" content=\"294\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/\",\"url\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/\",\"name\":\"SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2025\\\/03\\\/image-144.png\",\"datePublished\":\"2025-03-19T06:46:10+00:00\",\"dateModified\":\"2025-03-23T18:36:34+00:00\",\"description\":\"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger'eid efektiivseks andmehalduseks\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2025\\\/03\\\/image-144.png\",\"contentUrl\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2025\\\/03\\\/image-144.png\",\"width\":505,\"height\":294},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/sql-triggerite-loomine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL: Creating Triggers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Maria Smolina STUDY Portfolio | ENG |\",\"description\":\"Junior Software Developer Specialty\",\"publisher\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#organization\",\"name\":\"Maria Smolina STUDY Portfolio | ENG |\",\"url\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2025\\\/03\\\/cropped-cropped-cropped-logo.png\",\"contentUrl\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2025\\\/03\\\/cropped-cropped-cropped-logo.png\",\"width\":373,\"height\":373,\"caption\":\"Maria Smolina STUDY Portfolio | ENG |\"},\"image\":{\"@id\":\"https:\\\/\\\/mariasmolina24.thkit.ee\\\/wp\\\/eng\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine","description":"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger'eid efektiivseks andmehalduseks","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:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/","og_locale":"en_US","og_type":"article","og_title":"SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine","og_description":"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger'eid efektiivseks andmehalduseks","og_url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/","og_site_name":"Maria Smolina STUDY Portfolio | ENG |","article_modified_time":"2025-03-23T18:36:34+00:00","og_image":[{"width":505,"height":294,"url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/","url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/","name":"SQL Triggerite loomine - Maria Smolina STUDY Portfolio | ENG | Andmebaasi K\u00e4skude Seadistamine","isPartOf":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/#primaryimage"},"image":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/#primaryimage"},"thumbnailUrl":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png","datePublished":"2025-03-19T06:46:10+00:00","dateModified":"2025-03-23T18:36:34+00:00","description":"SQL Triggerite loomine v\u00f5imaldab automaatseid toiminguid andmebaasis. \u00d5pi, kuidas luua ja hallata SQL trigger'eid efektiivseks andmehalduseks","breadcrumb":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/#primaryimage","url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png","contentUrl":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/image-144.png","width":505,"height":294},{"@type":"BreadcrumbList","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/sql-triggerite-loomine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SQL: Creating Triggers"}]},{"@type":"WebSite","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/","name":"Maria Smolina STUDY Portfolio | ENG |","description":"Junior Software Developer Specialty","publisher":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#organization","name":"Maria Smolina STUDY Portfolio | ENG |","url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#\/schema\/logo\/image\/","url":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/cropped-cropped-cropped-logo.png","contentUrl":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-content\/uploads\/sites\/3\/2025\/03\/cropped-cropped-cropped-logo.png","width":373,"height":373,"caption":"Maria Smolina STUDY Portfolio | ENG |"},"image":{"@id":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/3396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=3396"}],"version-history":[{"count":0,"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/3396\/revisions"}],"wp:attachment":[{"href":"https:\/\/mariasmolina24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=3396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}