{"id":174,"date":"2025-09-03T11:14:18","date_gmt":"2025-09-03T08:14:18","guid":{"rendered":"https:\/\/programmerimineneondpreadator.wordpress.com\/?page_id=174"},"modified":"2025-09-03T11:14:18","modified_gmt":"2025-09-03T08:14:18","slug":"sql-trigerid","status":"publish","type":"page","link":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/","title":{"rendered":"SQL Trigerid"},"content":{"rendered":"\n<p>Triger (p\u00e4\u00e4stik, trigger) on protsess, mille abil tema sisse kirjutatud tegevused (INSERT, DELETE, UPDATE) automaatselt k\u00e4ivitatakse.<\/p>\n\n\n\n<p><strong>INSERT<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662\" alt=\"\" class=\"wp-image-181\" \/><\/figure>\n\n\n\n<p><strong>DELETE<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/aa7fc879-5361-468d-9c59-d92b498f4f4d.png?w=665\" alt=\"\" class=\"wp-image-183\" \/><\/figure>\n\n\n\n<p><strong>UPDATE<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/fa8f2f0a-1cf1-4efe-a584-730b87df477c.png?w=756\" alt=\"\" class=\"wp-image-185\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/3b872fea-ab17-41cf-a3a1-4c202fad1f20.png?w=650\" alt=\"\" class=\"wp-image-186\" \/><\/figure>\n\n\n\n<p><strong>XAMPP<\/strong><\/p>\n\n\n\n<p><strong>INSERT<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/08beee30-04de-4296-887d-03c4800dd610.png?w=692\" alt=\"\" class=\"wp-image-189\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/238eeac6-81bf-4ed5-a5e0-b5b31994b090.png?w=1024\" alt=\"\" class=\"wp-image-190\" \/><\/figure>\n\n\n\n<p><strong>DELETE<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/89e19b7c-d63b-40c8-aa0d-8201c0350681.png?w=684\" alt=\"\" class=\"wp-image-193\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/14f5c610-4e64-49a9-8379-937b22c86fe9.png?w=1024\" alt=\"\" class=\"wp-image-194\" \/><\/figure>\n\n\n\n<p><strong>UPDATE<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/9457eef3-50b7-44c0-a0fe-b553509465e0.png?w=691\" alt=\"\" class=\"wp-image-195\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/c5c6ad4c-34ed-4959-9c49-d9c136f5c1e8.png?w=1024\" alt=\"\" class=\"wp-image-196\" \/><\/figure>\n\n\n\n<p><strong>SQL  USERS<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/07c45721-c993-4c6c-8227-2c726174bada.png?w=837\" alt=\"\" class=\"wp-image-198\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/7d776880-56d4-4578-9849-0acc0108f2e6.png?w=782\" alt=\"\" class=\"wp-image-204\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/1e83953d-57d2-470c-8f68-803cf5e92c19.png?w=999\" alt=\"\" class=\"wp-image-200\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/b3d118a8-6300-4f16-8a78-86f6972c75e3.png?w=968\" alt=\"\" class=\"wp-image-202\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Triger (p\u00e4\u00e4stik, trigger) on protsess, mille abil tema sisse kirjutatud tegevused (INSERT, DELETE, UPDATE) automaatselt k\u00e4ivitatakse. INSERT DELETE UPDATE XAMPP INSERT DELETE UPDATE SQL USERS<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"class_list":["post-174","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Trigerid - Portfolio Nikita Gontsarov | eng<\/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:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Trigerid - Portfolio Nikita Gontsarov | eng\" \/>\n<meta property=\"og:description\" content=\"Triger (p\u00e4\u00e4stik, trigger) on protsess, mille abil tema sisse kirjutatud tegevused (INSERT, DELETE, UPDATE) automaatselt k\u00e4ivitatakse. INSERT DELETE UPDATE XAMPP INSERT DELETE UPDATE SQL USERS\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/\" \/>\n<meta property=\"og:site_name\" content=\"Portfolio Nikita Gontsarov | eng\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/\",\"url\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/\",\"name\":\"SQL Trigerid - Portfolio Nikita Gontsarov | eng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/programmerimineneondpreadator.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662\",\"datePublished\":\"2025-09-03T08:14:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/#primaryimage\",\"url\":\"https:\\\/\\\/programmerimineneondpreadator.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662\",\"contentUrl\":\"https:\\\/\\\/programmerimineneondpreadator.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/sql-trigerid\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Trigerid\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Portfolio Nikita Gontsarov | eng\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitagontsarov24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Trigerid - Portfolio Nikita Gontsarov | eng","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:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/","og_locale":"en_US","og_type":"article","og_title":"SQL Trigerid - Portfolio Nikita Gontsarov | eng","og_description":"Triger (p\u00e4\u00e4stik, trigger) on protsess, mille abil tema sisse kirjutatud tegevused (INSERT, DELETE, UPDATE) automaatselt k\u00e4ivitatakse. INSERT DELETE UPDATE XAMPP INSERT DELETE UPDATE SQL USERS","og_url":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/","og_site_name":"Portfolio Nikita Gontsarov | eng","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/","url":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/","name":"SQL Trigerid - Portfolio Nikita Gontsarov | eng","isPartOf":{"@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/#primaryimage"},"image":{"@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/#primaryimage"},"thumbnailUrl":"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662","datePublished":"2025-09-03T08:14:18+00:00","breadcrumb":{"@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/#primaryimage","url":"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662","contentUrl":"https:\/\/programmerimineneondpreadator.wordpress.com\/wp-content\/uploads\/2025\/09\/715e2a6e-d5dc-4e01-b335-2e61d3f7ed2d.png?w=662"},{"@type":"BreadcrumbList","@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/sql-trigerid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SQL Trigerid"}]},{"@type":"WebSite","@id":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/","name":"Portfolio Nikita Gontsarov | eng","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":0,"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/174\/revisions"}],"wp:attachment":[{"href":"https:\/\/nikitagontsarov24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}