{"version":"1.0","provider_name":"Anastasiia Radasheva Portfolio ENG","provider_url":"https:\/\/anastasiiaradasheva24.thkit.ee\/wp\/eng","author_name":"Radasheva","author_url":"https:\/\/anastasiiaradasheva24.thkit.ee\/wp\/eng\/author\/admin\/","title":"SQL TRIGERID - Anastasiia Radasheva Portfolio ENG","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"bErgzNAbLB\"><a href=\"https:\/\/anastasiiaradasheva24.thkit.ee\/wp\/eng\/sql-trigerid\/\">SQL TRIGERID<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/anastasiiaradasheva24.thkit.ee\/wp\/eng\/sql-trigerid\/embed\/#?secret=bErgzNAbLB\" width=\"600\" height=\"338\" title=\"&#8220;SQL TRIGERID&#8221; &#8212; Anastasiia Radasheva Portfolio ENG\" data-secret=\"bErgzNAbLB\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/anastasiiaradasheva24.thkit.ee\/wp\/eng\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Triger (p\u00e4\u00e4stik)- protsess, mille abil tema sisse kirjutatud(INSERT, DELETE, UPDATE) tegevused automaatselt k\u00e4ivitatakse. kontrollimiseks create database Create tables. Linnad and Logi. INSERT TIGER, mis j\u00e4lgib tabeli linnad t\u00e4iymine CONCAT() funktsioon liidab mitu tekstiv\u00e4lja \u00fcheks stringiks. Triggeris kasutatakse seda, et salvestada muudatuste logi, luua kokkuv\u00f5tteid v\u00f5i koostada kohandatud tekstiv\u00e4lju muudatuste p\u00f5hjal. trigeri tegevuse kontroll DELETE TRIGER, [&hellip;]"}