{"id":1584,"date":"2024-09-17T15:26:19","date_gmt":"2024-09-17T15:26:19","guid":{"rendered":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/?p=1584"},"modified":"2024-09-17T15:26:20","modified_gmt":"2024-09-17T15:26:20","slug":"sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd","status":"publish","type":"post","link":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/","title":{"rendered":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446"},"content":{"rendered":"\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#191724\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"create database triger2tabelid;\nuse triger2tabelid;\n\n\nCreate table linnad(\nlinnID int PRIMARY KEY identity(1,1),\nlinnanimi varchar(15),\nrahvaarv int);\n\n\nCreate table logi(\nid int PRIMARY KEY identity(1,1),\naeg DATETIME,\ntoiming  varchar(100),\nkasutaja varchar (200),\nandmed text\n);\n\n\nCREATE TABLE maakond(\nmaakondID int Primary KEY identity(1,1),\nmaakond varchar(100) UNIQUE);\nINSERT INTO maakond(maakond)\nVALUES ('Harjumaa');\nINSERT INTO maakond(maakond)\nVALUES ('P\u00e4rnumaa');\nSELECT * FROM maakond\n\n-- seoste loomine linnad --&gt; maakond\nALTER TABLE linnad ADD maakondID int;\nALTER TABLE linnad ADD CONSTRAINT fk_maakond\nFOREIGN KEY (maakondID) References maakond(maakondID) \n\nselect * from maakond ;\nselect * from linnad ;\" style=\"color:#e0def4;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki rose-pine\" style=\"background-color: #191724\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #31748F\">create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">database<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">triger2tabelid<\/span><span style=\"color: #E0DEF4\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">use<\/span><span style=\"color: #E0DEF4\"> triger2tabelid;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">Create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">table<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">linnad<\/span><span style=\"color: #E0DEF4\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">linnID <\/span><span style=\"color: #31748F\">int<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">PRIMARY KEY<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EB6F92; font-style: italic\">identity<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">,<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">linnanimi <\/span><span style=\"color: #31748F\">varchar<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">15<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">rahvaarv <\/span><span style=\"color: #31748F\">int<\/span><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">Create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">table<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">logi<\/span><span style=\"color: #E0DEF4\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">id <\/span><span style=\"color: #31748F\">int<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">PRIMARY KEY<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EB6F92; font-style: italic\">identity<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">,<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">aeg <\/span><span style=\"color: #31748F\">DATETIME<\/span><span style=\"color: #E0DEF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">toiming  <\/span><span style=\"color: #31748F\">varchar<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">100<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">kasutaja <\/span><span style=\"color: #31748F\">varchar<\/span><span style=\"color: #E0DEF4\"> (<\/span><span style=\"color: #EBBCBA\">200<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">andmed <\/span><span style=\"color: #31748F\">text<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">CREATE<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">TABLE<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">maakond<\/span><span style=\"color: #E0DEF4\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">maakondID <\/span><span style=\"color: #31748F\">int<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">Primary KEY<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EB6F92; font-style: italic\">identity<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">,<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E0DEF4\">maakond <\/span><span style=\"color: #31748F\">varchar<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #EBBCBA\">100<\/span><span style=\"color: #E0DEF4\">) <\/span><span style=\"color: #31748F\">UNIQUE<\/span><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">INSERT INTO<\/span><span style=\"color: #E0DEF4\"> maakond(maakond)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">VALUES<\/span><span style=\"color: #E0DEF4\"> (<\/span><span style=\"color: #F6C177\">&#39;Harjumaa&#39;<\/span><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">INSERT INTO<\/span><span style=\"color: #E0DEF4\"> maakond(maakond)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">VALUES<\/span><span style=\"color: #E0DEF4\"> (<\/span><span style=\"color: #F6C177\">&#39;P\u00e4rnumaa&#39;<\/span><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">SELECT<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">FROM<\/span><span style=\"color: #E0DEF4\"> maakond<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #908CAA; font-style: italic\">--<\/span><span style=\"color: #6E6A86; font-style: italic\"> seoste loomine linnad --&gt; maakond<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">ALTER<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">TABLE<\/span><span style=\"color: #E0DEF4\"> linnad <\/span><span style=\"color: #31748F\">ADD<\/span><span style=\"color: #E0DEF4\"> maakondID <\/span><span style=\"color: #31748F\">int<\/span><span style=\"color: #E0DEF4\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">ALTER<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">TABLE<\/span><span style=\"color: #E0DEF4\"> linnad <\/span><span style=\"color: #31748F\">ADD<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">CONSTRAINT<\/span><span style=\"color: #E0DEF4\"> fk_maakond<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">FOREIGN KEY<\/span><span style=\"color: #E0DEF4\"> (maakondID) <\/span><span style=\"color: #31748F\">References<\/span><span style=\"color: #E0DEF4\"> maakond(maakondID) <\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> maakond ;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad ;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\"><strong><em>Insert trigger <\/em><\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#191724\"><\/span><span role=\"button\" data-code=\"create trigger linnaLisamine\non linnad\nfor insert\nas insert into logi(kasutaja, aeg, toiming, andmed)\nselect user, getdate(), 'linn on lisatud', concat(l.linnanimi, ', ', m.maakond)\nfrom linnad l\ninner join maakond m \non m.maakondID=l.maakondID\n--kontrollimiseks\ninsert into linnad(linnanimi, rahvaarv, maakondID)\nvalues ('Tallinn', 436863, 1);\nselect * from linnad;\nselect * from logi;\" style=\"color:#e0def4\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><\/span><pre class=\"shiki rose-pine\" style=\"background-color: #191724\"><code><span class=\"line\"><span style=\"color: #31748F\">create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">trigger<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">linnaLisamine<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> linnad<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">for<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">insert<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">as<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">insert into<\/span><span style=\"color: #E0DEF4\"> logi(kasutaja, aeg, toiming, andmed)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> user, <\/span><span style=\"color: #EB6F92;font-style: italic\">getdate<\/span><span style=\"color: #E0DEF4\">(), <\/span><span style=\"color: #F6C177\">&#039;linn on lisatud&#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #EB6F92;font-style: italic\">concat<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #31748F\">l<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnanimi<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #F6C177\">&#039;, &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">m<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakond<\/span><span style=\"color: #E0DEF4\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad l<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">inner join<\/span><span style=\"color: #E0DEF4\"> maakond m <\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">m<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID=l<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #908CAA;font-style: italic\">--<\/span><span style=\"color: #6E6A86;font-style: italic\">kontrollimiseks<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">insert into<\/span><span style=\"color: #E0DEF4\"> linnad(linnanimi, rahvaarv, maakondID)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">values<\/span><span style=\"color: #E0DEF4\"> (<\/span><span style=\"color: #F6C177\">&#039;Tallinn&#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #EBBCBA\">436863<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> logi;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt.png\" alt=\"\" class=\"wp-image-1499\"\/><\/figure>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\"><strong><em>Delete trigger<\/em><\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#191724\"><\/span><span role=\"button\" data-code=\"-- kustutamine\ncreate trigger linnaKustutamine\non linnad\nfor delete\nas insert into logi(kasutaja, aeg, toiming, andmed)\nselect user, getdate(), 'linn on kustutatud', concat(deleted.linnanimi, ', ', m.maakond)\nfrom deleted\ninner join maakond m \non deleted.maakondID=m.maakondID\n--kontroll\ndelete from linnad \nwhere linnID=1;\nselect * from linnad;\nselect * from logi;\" style=\"color:#e0def4\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><\/span><pre class=\"shiki rose-pine\" style=\"background-color: #191724\"><code><span class=\"line\"><span style=\"color: #908CAA;font-style: italic\">--<\/span><span style=\"color: #6E6A86;font-style: italic\"> kustutamine<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">trigger<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">linnaKustutamine<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> linnad<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">for<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">delete<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">as<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">insert into<\/span><span style=\"color: #E0DEF4\"> logi(kasutaja, aeg, toiming, andmed)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> user, <\/span><span style=\"color: #EB6F92;font-style: italic\">getdate<\/span><span style=\"color: #E0DEF4\">(), <\/span><span style=\"color: #F6C177\">&#039;linn on kustutatud&#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #EB6F92;font-style: italic\">concat<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #31748F\">deleted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnanimi<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #F6C177\">&#039;, &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">m<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakond<\/span><span style=\"color: #E0DEF4\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> deleted<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">inner join<\/span><span style=\"color: #E0DEF4\"> maakond m <\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">deleted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID=m<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #908CAA;font-style: italic\">--<\/span><span style=\"color: #6E6A86;font-style: italic\">kontroll<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">delete<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad <\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">where<\/span><span style=\"color: #E0DEF4\"> linnID<\/span><span style=\"color: #31748F\">=<\/span><span style=\"color: #EBBCBA\">1<\/span><span style=\"color: #E0DEF4\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> logi;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt-1.png\" alt=\"\" class=\"wp-image-1500\"\/><\/figure>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\"><strong><em>Update trigger<\/em><\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#191724\"><\/span><span role=\"button\" data-code=\"-- uuesndamine\ncreate trigger linnaUuendamine\non linnad\nfor update\nas \ninsert into logi(kasutaja, aeg, toiming, andmed)\nselect user, getdate(), 'linn on kustutatud', concat('Vanad andmed : ', deleted.linnanimi, ', ', m1.maakond,\n'Uuendanud andmed : ', inserted.linnanimi, ', ', m2.maakond)\nfrom deleted\ninner join inserted on deleted.linnID=inserted.linnID\ninner join maakond m1 on deleted.maakondID=m1.maakondID\ninner join maakond m2 on inserted.maakondID=m2.maakondID;\nupdate linnad set linnanimi='Tallinn-V\u00e4ike', maakondID=2\nwhere linnID=2;\nselect * from linnad;\" style=\"color:#e0def4\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><\/span><pre class=\"shiki rose-pine\" style=\"background-color: #191724\"><code><span class=\"line\"><span style=\"color: #908CAA;font-style: italic\">--<\/span><span style=\"color: #6E6A86;font-style: italic\"> uuesndamine<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">create<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">trigger<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #EBBCBA\">linnaUuendamine<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> linnad<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">for<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">update<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">as<\/span><span style=\"color: #E0DEF4\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">insert into<\/span><span style=\"color: #E0DEF4\"> logi(kasutaja, aeg, toiming, andmed)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> user, <\/span><span style=\"color: #EB6F92;font-style: italic\">getdate<\/span><span style=\"color: #E0DEF4\">(), <\/span><span style=\"color: #F6C177\">&#039;linn on kustutatud&#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #EB6F92;font-style: italic\">concat<\/span><span style=\"color: #E0DEF4\">(<\/span><span style=\"color: #F6C177\">&#039;Vanad andmed : &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">deleted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnanimi<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #F6C177\">&#039;, &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">m1<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakond<\/span><span style=\"color: #E0DEF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F6C177\">&#039;Uuendanud andmed : &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">inserted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnanimi<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #F6C177\">&#039;, &#039;<\/span><span style=\"color: #E0DEF4\">, <\/span><span style=\"color: #31748F\">m2<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakond<\/span><span style=\"color: #E0DEF4\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> deleted<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">inner join<\/span><span style=\"color: #E0DEF4\"> inserted <\/span><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">deleted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnID=inserted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">linnID<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">inner join<\/span><span style=\"color: #E0DEF4\"> maakond m1 <\/span><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">deleted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID=m1<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">inner join<\/span><span style=\"color: #E0DEF4\"> maakond m2 <\/span><span style=\"color: #31748F\">on<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">inserted<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID=m2<\/span><span style=\"color: #E0DEF4\">.<\/span><span style=\"color: #31748F\">maakondID<\/span><span style=\"color: #E0DEF4\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">update<\/span><span style=\"color: #E0DEF4\"> linnad <\/span><span style=\"color: #31748F\">set<\/span><span style=\"color: #E0DEF4\"> linnanimi<\/span><span style=\"color: #31748F\">=<\/span><span style=\"color: #F6C177\">&#039;Tallinn-V\u00e4ike&#039;<\/span><span style=\"color: #E0DEF4\">, maakondID<\/span><span style=\"color: #31748F\">=<\/span><span style=\"color: #EBBCBA\">2<\/span><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">where<\/span><span style=\"color: #E0DEF4\"> linnID<\/span><span style=\"color: #31748F\">=<\/span><span style=\"color: #EBBCBA\">2<\/span><span style=\"color: #E0DEF4\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #31748F\">select<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">*<\/span><span style=\"color: #E0DEF4\"> <\/span><span style=\"color: #31748F\">from<\/span><span style=\"color: #E0DEF4\"> linnad;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt-2.png\" alt=\"\" class=\"wp-image-1501\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Insert trigger Delete trigger Update trigger<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1584","post","type-post","status-publish","format-standard","hentry","category-andmebaasisusteemide-alused"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian<\/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:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-\u0441\u0435\u0440\u0432\u0435\u0440-\u0442\u0440\u0438\u0433\u0435\u0440\u044b-\u043d\u0430-\u043e\u0441\u043d\u043e\u0432\u0435-\u0434\u0432\u0443\u0445-\u0441\u0432\u044f\u0437\u0430\u043d\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"og:description\" content=\"Insert trigger Delete trigger Update trigger\" \/>\n<meta property=\"og:url\" content=\"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-\u0441\u0435\u0440\u0432\u0435\u0440-\u0442\u0440\u0438\u0433\u0435\u0440\u044b-\u043d\u0430-\u043e\u0441\u043d\u043e\u0432\u0435-\u0434\u0432\u0443\u0445-\u0441\u0432\u044f\u0437\u0430\u043d\/\" \/>\n<meta property=\"og:site_name\" content=\"Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-17T15:26:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-17T15:26:20+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u043c\u0438\u043d\u0443\u0442\u0430\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/person\\\/be38dc15d5db1134b3b156c050997e18\"},\"headline\":\"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\",\"datePublished\":\"2024-09-17T15:26:19+00:00\",\"dateModified\":\"2024-09-17T15:26:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/\"},\"wordCount\":14,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/pilt.png\",\"articleSection\":[\"Andmebaasis\u00fcsteemide alused\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/\",\"name\":\"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/pilt.png\",\"datePublished\":\"2024-09-17T15:26:19+00:00\",\"dateModified\":\"2024-09-17T15:26:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#primaryimage\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/pilt.png\",\"contentUrl\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/pilt.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#website\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\",\"name\":\"Valeria Allik portfoolio | Russian\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\",\"name\":\"Valeria Allik portfoolio | Russian\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/09\\\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png\",\"contentUrl\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/09\\\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png\",\"width\":1080,\"height\":1080,\"caption\":\"Valeria Allik portfoolio | Russian\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/person\\\/be38dc15d5db1134b3b156c050997e18\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\"],\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian","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:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-\u0441\u0435\u0440\u0432\u0435\u0440-\u0442\u0440\u0438\u0433\u0435\u0440\u044b-\u043d\u0430-\u043e\u0441\u043d\u043e\u0432\u0435-\u0434\u0432\u0443\u0445-\u0441\u0432\u044f\u0437\u0430\u043d\/","og_locale":"ru_RU","og_type":"article","og_title":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian","og_description":"Insert trigger Delete trigger Update trigger","og_url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-\u0441\u0435\u0440\u0432\u0435\u0440-\u0442\u0440\u0438\u0433\u0435\u0440\u044b-\u043d\u0430-\u043e\u0441\u043d\u043e\u0432\u0435-\u0434\u0432\u0443\u0445-\u0441\u0432\u044f\u0437\u0430\u043d\/","og_site_name":"Valeria Allik portfoolio | Russian","article_published_time":"2024-09-17T15:26:19+00:00","article_modified_time":"2024-09-17T15:26:20+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"admin","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"1 \u043c\u0438\u043d\u0443\u0442\u0430"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#article","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/"},"author":{"name":"admin","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/person\/be38dc15d5db1134b3b156c050997e18"},"headline":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446","datePublished":"2024-09-17T15:26:19+00:00","dateModified":"2024-09-17T15:26:20+00:00","mainEntityOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/"},"wordCount":14,"commentCount":0,"publisher":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt.png","articleSection":["Andmebaasis\u00fcsteemide alused"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/","name":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 - Valeria Allik portfoolio | Russian","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#website"},"primaryImageOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#primaryimage"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt.png","datePublished":"2024-09-17T15:26:19+00:00","dateModified":"2024-09-17T15:26:20+00:00","breadcrumb":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#primaryimage","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt.png","contentUrl":"https:\/\/valeriaallik23.thkit.ee\/wp\/wp-content\/uploads\/2024\/09\/pilt.png"},{"@type":"BreadcrumbList","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80-%d1%82%d1%80%d0%b8%d0%b3%d0%b5%d1%80%d1%8b-%d0%bd%d0%b0-%d0%be%d1%81%d0%bd%d0%be%d0%b2%d0%b5-%d0%b4%d0%b2%d1%83%d1%85-%d1%81%d0%b2%d1%8f%d0%b7%d0%b0%d0%bd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/"},{"@type":"ListItem","position":2,"name":"SQL \u0421\u0435\u0440\u0432\u0435\u0440 \u0422\u0440\u0438\u0433\u0435\u0440\u044b \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0434\u0432\u0443\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446"}]},{"@type":"WebSite","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#website","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/","name":"Valeria Allik portfoolio | Russian","description":"","publisher":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization","name":"Valeria Allik portfoolio | Russian","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/logo\/image\/","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-content\/uploads\/sites\/2\/2024\/09\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png","contentUrl":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-content\/uploads\/sites\/2\/2024\/09\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png","width":1080,"height":1080,"caption":"Valeria Allik portfoolio | Russian"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/person\/be38dc15d5db1134b3b156c050997e18","name":"admin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/valeriaallik23.thkit.ee\/wp"],"url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/comments?post=1584"}],"version-history":[{"count":1,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1584\/revisions"}],"predecessor-version":[{"id":1585,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1584\/revisions\/1585"}],"wp:attachment":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/categories?post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/tags?post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}