{"id":632,"date":"2025-03-26T08:54:55","date_gmt":"2025-03-26T08:54:55","guid":{"rendered":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632"},"modified":"2025-03-26T09:33:51","modified_gmt":"2025-03-26T09:33:51","slug":"xampp-trigerite-loomine-ja-kasutamine","status":"publish","type":"page","link":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632","title":{"rendered":"XAMPP &#8211; Trigerite loomine ja kasutamine"},"content":{"rendered":"\n<p><strong>Andmebaasi ja tabelite loomine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE autoregister(\nautoID int Auto_increment PRIMARY KEY,\nmark varchar(15) NOT NULL,\nmudel varchar(15) NOT NULL,\naasta INT,\nomanik VARCHAR(50),\nregistreerimiseKuupaev DATE\n);\n  \nCREATE TABLE logitabel(\nid int Auto_increment PRIMARY KEY,\ntoiming  varchar(100),\naeg DATETIME,\nautoAndmed TEXT\n);\n<\/pre><\/div>\n\n\n<p><strong>Auto lisamine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO logitabel(toiming, aeg, autoAndmed)\nSELECT\n&#039;On tehtud INSERT k\u00e4sk&#039;,\nNOW(),\nCONCAT(&#039;Mark: &#039;, NEW.mark, &#039;, Mudel: &#039;, NEW.mudel, &#039;, Omanik: &#039;, NEW.omanik);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"460\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png\" alt=\"\" class=\"wp-image-633\" style=\"width:820px;height:auto\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png 727w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1-300x190.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1-150x95.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1-600x380.png 600w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<p><strong>KONTROLL trigger logitabel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-1024x446.png\" alt=\"\" class=\"wp-image-636\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-1024x446.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-300x131.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-768x335.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-150x65.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert-600x261.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/insert.png 1205w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Auto Kustutamine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nINSERT INTO logitabel(toiming, aeg, autoAndmed)\nSELECT\n&#039;On tehtud DELETE k\u00e4sk&#039;,\nNOW(),\nCONCAT(&#039;Mark: &#039;, OLD.mark, &#039;, Mudel: &#039;, OLD.mudel, &#039;, Omanik: &#039;, OLD.omanik);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"639\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/2.png\" alt=\"\" class=\"wp-image-634\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/2.png 727w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/2-300x264.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/2-150x132.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/2-600x527.png 600w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/figure>\n\n\n\n<p><strong>KONTROLL TRIGER kustutamine<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"607\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete.png\" alt=\"\" class=\"wp-image-637\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete.png 979w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete-300x186.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete-768x476.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete-150x93.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/delete-600x372.png 600w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/figure>\n\n\n\n<p><strong>Auto Uuendamine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO logitabel(toiming, aeg, autoAndmed)\nSELECT\n&#039;On tehtud UPDATE k\u00e4sk&#039;,\nNOW(),\nCONCAT(&#039;Vanad andmed - Mark: &#039;, OLD.mark, &#039;, Mudel: &#039;, OLD.mudel, &#039;, Omanik: &#039;, OLD.omanik,\n&#039;\\nUued andmed - Mark: &#039;, NEW.mark, &#039;, Mudel: &#039;, NEW.mudel, &#039;, Omanik: &#039;, NEW.omanik)\nFROM autoregister a\nINNER JOIN autoregister ar\nON a.autoID=ar.autoID\nWHERE NEW.autoID=a.autoID;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"577\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/3.png\" alt=\"\" class=\"wp-image-635\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/3.png 701w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/3-300x247.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/3-150x123.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/3-600x494.png 600w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/figure>\n\n\n\n<p><strong>KONTROLL TRIGGER uuendamine<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"674\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-1024x674.png\" alt=\"\" class=\"wp-image-638\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-1024x674.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-300x197.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-768x506.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-150x99.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated-600x395.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/updated.png 1106w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Autokindlustus lisamine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE kindlustus (\n    kindlustusID INT AUTO_INCREMENT PRIMARY KEY,\n    autoID INT,\n    kindlustusFirma VARCHAR(100),\n    poliisiNumber VARCHAR(100),\n    kehtivKuni DATE,\n    FOREIGN KEY (autoID) REFERENCES autoregister(autoID)\n        ON DELETE CASCADE\n        ON UPDATE CASCADE\n);\n<\/pre><\/div>\n\n\n<p>autoID \u2014 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447, \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u043d\u0430 autoregister.<\/p>\n\n\n\n<p>ON DELETE CASCADE \u2014 \u0435\u0441\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0432\u0442\u043e, \u0443\u0434\u0430\u043b\u0438\u0442\u0441\u044f \u0438 \u0435\u0433\u043e \u0441\u0442\u0440\u0430\u0445\u043e\u0432\u043a\u0430<\/p>\n\n\n\n<p>ON UPDATE CASCADE \u2014 \u0435\u0441\u043b\u0438 autoID \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0441\u044f, \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0438 \u0442\u0443\u0442<\/p>\n\n\n\n<p><strong>Kindlustus andmed lisamine<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO kindlustus (autoID, kindlustusFirma, poliisiNumber, kehtivKuni)\nVALUES (1, &#039;If Kindlustus&#039;, &#039;POL12345678&#039;, &#039;2025-12-31&#039;);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"299\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus.png\" alt=\"\" class=\"wp-image-641\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus.png 816w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus-300x110.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus-768x281.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus-150x55.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/kindlustus-600x220.png 600w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/figure>\n\n\n\n<p><strong>Kontroll seosed<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT a.mark, a.mudel, k.kindlustusFirma, k.kehtivKuni\nFROM autoregister a\nJOIN kindlustus k ON a.autoID = k.autoID;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"289\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind.png\" alt=\"\" class=\"wp-image-642\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind.png 977w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind-300x89.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind-768x227.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind-150x44.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/seoskind-600x177.png 600w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<p><strong>UUENDAMINE trigger koos kasutaja ja kindlustuse seostega<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TRIGGER autoUuendamine\nAFTER UPDATE ON autoregister\nFOR EACH ROW\nINSERT INTO logitabel (toiming, aeg, autoAndmed)\nSELECT\n  CONCAT(&#039;UPDATE tegi kasutaja: &#039;, USER()),\n  NOW(),\n  CONCAT(&#039;Mark: &#039;, NEW.mark,\n         &#039;, Mudel: &#039;, NEW.mudel,\n         &#039;, Omanik: &#039;, IFNULL(NEW.omanik, &#039;puudub&#039;),\n         &#039;, Kindlustus: &#039;, IFNULL(k.kindlustusFirma, &#039;puudub&#039;),\n         &#039;, Poliisi nr: &#039;, IFNULL(k.poliisiNumber, &#039;puudub&#039;),\n         &#039;, Kehtib kuni: &#039;, IFNULL(k.kehtivKuni, &#039;puudub&#039;))\nFROM kindlustus k\nWHERE k.autoID = NEW.autoID;\n\n<\/pre><\/div>\n\n\n<p><strong>KONTROLL<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE autoregister\nSET omanik = &#039;Uus Omanik&#039;\nWHERE autoID = 200;\nSELECT * FROM logitabel\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"30\" src=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-1024x30.png\" alt=\"\" class=\"wp-image-646\" srcset=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-1024x30.png 1024w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-300x9.png 300w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-768x23.png 768w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-150x4.png 150w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1-600x18.png 600w, https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/333-1.png 1080w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Andmebaasi ja tabelite loomine Auto lisamine KONTROLL trigger logitabel Auto Kustutamine KONTROLL TRIGER kustutamine Auto Uuendamine KONTROLL TRIGGER uuendamine Autokindlustus lisamine autoID \u2014 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447, \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u043d\u0430 autoregister. ON DELETE CASCADE \u2014 \u0435\u0441\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0432\u0442\u043e, \u0443\u0434\u0430\u043b\u0438\u0442\u0441\u044f \u0438 \u0435\u0433\u043e \u0441\u0442\u0440\u0430\u0445\u043e\u0432\u043a\u0430 ON UPDATE CASCADE \u2014 \u0435\u0441\u043b\u0438 autoID \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0441\u044f, \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0438 \u0442\u0443\u0442 Kindlustus andmed lisamine Kontroll seosed UUENDAMINE &#8230; <a title=\"XAMPP &#8211; Trigerite loomine ja kasutamine\" class=\"read-more\" href=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632\" aria-label=\"Read more about XAMPP &#8211; Trigerite loomine ja kasutamine\">Read more<\/a><\/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-632","page","type-page","status-publish"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \/ 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:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"og:description\" content=\"Andmebaasi ja tabelite loomine Auto lisamine KONTROLL trigger logitabel Auto Kustutamine KONTROLL TRIGER kustutamine Auto Uuendamine KONTROLL TRIGGER uuendamine Autokindlustus lisamine autoID \u2014 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447, \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u043d\u0430 autoregister. ON DELETE CASCADE \u2014 \u0435\u0441\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0432\u0442\u043e, \u0443\u0434\u0430\u043b\u0438\u0442\u0441\u044f \u0438 \u0435\u0433\u043e \u0441\u0442\u0440\u0430\u0445\u043e\u0432\u043a\u0430 ON UPDATE CASCADE \u2014 \u0435\u0441\u043b\u0438 autoID \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0441\u044f, \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0438 \u0442\u0443\u0442 Kindlustus andmed lisamine Kontroll seosed UUENDAMINE ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632\" \/>\n<meta property=\"og:site_name\" content=\"Gleb Dranitsyn \/ Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-26T09:33:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"727\" \/>\n\t<meta property=\"og:image:height\" content=\"460\" \/>\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 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632\",\"name\":\"XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \\\/ Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1.png\",\"datePublished\":\"2025-03-26T08:54:55+00:00\",\"dateModified\":\"2025-03-26T09:33:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632#primaryimage\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1.png\",\"contentUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/1.png\",\"width\":727,\"height\":460},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?page_id=632#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"XAMPP &#8212; Trigerite loomine ja kasutamine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"description\":\"Tarkvara aarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Gleb Dranitsyn \\\/ Portfolio\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"contentUrl\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-cropped-logo1.jpg\",\"width\":400,\"height\":171,\"caption\":\"Gleb Dranitsyn \\\/ Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/glebdranitson24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \/ 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:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632","og_locale":"et_EE","og_type":"article","og_title":"XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \/ Portfolio","og_description":"Andmebaasi ja tabelite loomine Auto lisamine KONTROLL trigger logitabel Auto Kustutamine KONTROLL TRIGER kustutamine Auto Uuendamine KONTROLL TRIGGER uuendamine Autokindlustus lisamine autoID \u2014 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447, \u0441\u0441\u044b\u043b\u0430\u0435\u0442\u0441\u044f \u043d\u0430 autoregister. ON DELETE CASCADE \u2014 \u0435\u0441\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0430\u0432\u0442\u043e, \u0443\u0434\u0430\u043b\u0438\u0442\u0441\u044f \u0438 \u0435\u0433\u043e \u0441\u0442\u0440\u0430\u0445\u043e\u0432\u043a\u0430 ON UPDATE CASCADE \u2014 \u0435\u0441\u043b\u0438 autoID \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0441\u044f, \u043e\u0431\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0438 \u0442\u0443\u0442 Kindlustus andmed lisamine Kontroll seosed UUENDAMINE ... Read more","og_url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632","og_site_name":"Gleb Dranitsyn \/ Portfolio","article_modified_time":"2025-03-26T09:33:51+00:00","og_image":[{"width":727,"height":460,"url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632","name":"XAMPP - Trigerite loomine ja kasutamine - Gleb Dranitsyn \/ Portfolio","isPartOf":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632#primaryimage"},"image":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632#primaryimage"},"thumbnailUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png","datePublished":"2025-03-26T08:54:55+00:00","dateModified":"2025-03-26T09:33:51+00:00","breadcrumb":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632#primaryimage","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png","contentUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/1.png","width":727,"height":460},{"@type":"BreadcrumbList","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/?page_id=632#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/glebdranitson24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"XAMPP &#8212; Trigerite loomine ja kasutamine"}]},{"@type":"WebSite","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#website","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","name":"Gleb Dranitsyn \/ Portfolio","description":"Tarkvara aarendaja","publisher":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/glebdranitson24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#organization","name":"Gleb Dranitsyn \/ Portfolio","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","contentUrl":"https:\/\/glebdranitson24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/cropped-cropped-logo1.jpg","width":400,"height":171,"caption":"Gleb Dranitsyn \/ Portfolio"},"image":{"@id":"https:\/\/glebdranitson24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=632"}],"version-history":[{"count":3,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/632\/revisions"}],"predecessor-version":[{"id":647,"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/632\/revisions\/647"}],"wp:attachment":[{"href":"https:\/\/glebdranitson24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}