{"id":1576,"date":"2024-09-17T15:22:55","date_gmt":"2024-09-17T15:22:55","guid":{"rendered":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/?p=1576"},"modified":"2024-09-17T15:22:56","modified_gmt":"2024-09-17T15:22:56","slug":"ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80","status":"publish","type":"post","link":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/","title":{"rendered":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-58.png?w=823\" alt=\"\" class=\"wp-image-736\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PROTSEDUURID<\/strong> <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Andmete lisamine tabelisse FilmType (Filmtype ja kirjaldus sisestab kasutaja kui k\u00e4ivitab protseduuri)<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-60.png?w=1024\" alt=\"\" class=\"wp-image-741\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>TULEMUS :<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-61.png?w=725\" alt=\"\" class=\"wp-image-743\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. Kustutamis protseduur, kustutab filmt\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse)<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-62.png?w=779\" alt=\"\" class=\"wp-image-745\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-63.png?w=1024\" alt=\"\" class=\"wp-image-746\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimene t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik filmit\u00fcbid)<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-64.png?w=655\" alt=\"\" class=\"wp-image-748\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-65.png?w=496\" alt=\"\" class=\"wp-image-749\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4. Uuendamis protseduur kasutaja sisestab uuendatus filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-66.png?w=993\" alt=\"\" class=\"wp-image-750\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-67.png?w=570\" alt=\"\" class=\"wp-image-751\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><em><strong>ALTER TABLE<\/strong> <strong>tabeline ADD<\/strong> veergunimi t\u00fc\u00fcp &#8212; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8212; <strong>\u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0433\u043e<\/strong><\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>ALTER TABLE tabelinimi DROP<\/strong> veergunimi t\u00fc\u00fcp &#8212; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8212; <strong>\u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u043e\u043b\u0431\u0446\u0430<\/strong><\/em><\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nALTER TABLE filmtype ADD test varchar(25);\nALTER TABLE filmtype ADD test int;\nALTER TABLE filmtype DROP test;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nBEGIN\nIF valik=&#039;ADD&#039; THEN \n\tSET @STMT = Concat(&#039;ALTER TABLE filmType ADD &#039;, veerunimi, &#039; &#039;, tyyp);\n\tELSEIF valik=&#039;DROP&#039; THEN\n    SET @STMT = Concat(&#039;ALTER TABLE filmType DROP &#039;, veerunimi, &#039; &#039;, tyyp);\n    END IF ;\nPREPARE S FROM @STMT;\nEXECUTE S;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-68.png?w=700\" alt=\"\" class=\"wp-image-758\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-69.png?w=822\" alt=\"\" class=\"wp-image-760\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-70.png?w=238\" alt=\"\" class=\"wp-image-761\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-large-font-size wp-block-paragraph\"><strong><em>HINDAMISE \u00dcLESANNE<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041d\u0410 \u041e\u0426\u0415\u041d\u041a\u0423 3<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1) \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 (INSERT) \u0432 \u043b\u044e\u0431\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0411\u0414 \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code aligncenter\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nBEGIN\nINSERT rezisoor(eesnimi, perenimi) \nVALUES (uusNimi, uusPerekonnanimi);\nSELECT * FROM rezisoor;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-72.png?w=465\" alt=\"\" class=\"wp-image-764\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2) \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u017eanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nBEGIN\n SELECT * FROM rezisoor;\n DELETE FROM rezisoor\n WHERE rezisoorID = kustutamineID;\n SELECT * FROM rezisoor;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-73.png?w=303\" alt=\"\" class=\"wp-image-766\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3) \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 \u0438\u043c\u0435\u043d\u0438<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nBEGIN\nset @STMT = concat(&#039;DROP TABLE &#039;, rezisoorNimi);\nPREPARE S FROM @STMT;\nEXECUTE S;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-74.png?w=1024\" alt=\"\" class=\"wp-image-767\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041d\u0410 \u041e\u0426\u0415\u041d\u041a\u0423 4<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1) \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 (ALTER) \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0440\u0435\u0436\u0438\u0441\u0435\u0440<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nBEGIN\nIF valik=&#039;ADD&#039; THEN \n\tSET @STMT = Concat(&#039;ALTER TABLE rezisoor ADD &#039;, veerunimi, &#039; &#039;, tyyp);\n\tELSEIF valik=&#039;DROP&#039; THEN\n    SET @STMT = Concat(&#039;ALTER TABLE rezisoor DROP &#039;, veerunimi, &#039; &#039;, tyyp);\n    END IF ;\nPREPARE S FROM @STMT;\nEXECUTE S;\nEND\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>PROTSEDUURID TULEMUS : 2. Kustutamis protseduur, kustutab filmt\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse) 3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimene t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik filmit\u00fcbid) 4. Uuendamis protseduur kasutaja sisestab uuendatus filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi ALTER TABLE tabeline ADD veergunimi t\u00fc\u00fcp &#8212; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8212; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 [&hellip;]<\/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-1576","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>AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - 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\/ab-\u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"og:description\" content=\"PROTSEDUURID TULEMUS : 2. Kustutamis protseduur, kustutab filmt\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse) 3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimene t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik filmit\u00fcbid) 4. Uuendamis protseduur kasutaja sisestab uuendatus filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi ALTER TABLE tabeline ADD veergunimi t\u00fc\u00fcp &#8212; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8212; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\/\" \/>\n<meta property=\"og:site_name\" content=\"Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-17T15:22:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-17T15:22:56+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\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/person\\\/be38dc15d5db1134b3b156c050997e18\"},\"headline\":\"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\",\"datePublished\":\"2024-09-17T15:22:55+00:00\",\"dateModified\":\"2024-09-17T15:22:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/\"},\"wordCount\":127,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/pilt-58.png?w=823\",\"articleSection\":[\"Andmebaasis\u00fcsteemide alused\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/\",\"name\":\"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - Valeria Allik portfoolio | Russian\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/pilt-58.png?w=823\",\"datePublished\":\"2024-09-17T15:22:55+00:00\",\"dateModified\":\"2024-09-17T15:22:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/pilt-58.png?w=823\",\"contentUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/pilt-58.png?w=823\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\"}]},{\"@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":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - 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\/ab-\u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\/","og_locale":"ru_RU","og_type":"article","og_title":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - Valeria Allik portfoolio | Russian","og_description":"PROTSEDUURID TULEMUS : 2. Kustutamis protseduur, kustutab filmt\u00fc\u00fcp tema id j\u00e4rgi (kasutaja sisestab id ja siis filmt\u00fc\u00fcp kustutakse) 3. Otsing sisestatud t\u00e4hte j\u00e4rgi (kasutaja sisestab filmit\u00fc\u00fcpi Esimene t\u00e4ht ja siis n\u00e4idetakse k\u00f5ik filmit\u00fcbid) 4. Uuendamis protseduur kasutaja sisestab uuendatus filmit\u00fc\u00fcbi sisestatud id j\u00e4rgi ALTER TABLE tabeline ADD veergunimi t\u00fc\u00fcp &#8212; \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0442\u0430\u0431\u043b\u0438\u0446\u044b &#8212; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 [&hellip;]","og_url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\/","og_site_name":"Valeria Allik portfoolio | Russian","article_published_time":"2024-09-17T15:22:55+00:00","article_modified_time":"2024-09-17T15:22:56+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\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#article","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/"},"author":{"name":"admin","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/person\/be38dc15d5db1134b3b156c050997e18"},"headline":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440","datePublished":"2024-09-17T15:22:55+00:00","dateModified":"2024-09-17T15:22:56+00:00","mainEntityOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/"},"wordCount":127,"commentCount":0,"publisher":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#primaryimage"},"thumbnailUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-58.png?w=823","articleSection":["Andmebaasis\u00fcsteemide alused"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/","name":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440 - Valeria Allik portfoolio | Russian","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#website"},"primaryImageOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#primaryimage"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#primaryimage"},"thumbnailUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-58.png?w=823","datePublished":"2024-09-17T15:22:55+00:00","dateModified":"2024-09-17T15:22:56+00:00","breadcrumb":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#primaryimage","url":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-58.png?w=823","contentUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/03\/pilt-58.png?w=823"},{"@type":"BreadcrumbList","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%ba%d0%b8%d0%bd%d0%be%d1%82%d0%b5%d0%b0%d1%82%d1%80\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/"},{"@type":"ListItem","position":2,"name":"AB \u041a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440"}]},{"@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\/1576","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=1576"}],"version-history":[{"count":1,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1576\/revisions"}],"predecessor-version":[{"id":1577,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1576\/revisions\/1577"}],"wp:attachment":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=1576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/categories?post=1576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/tags?post=1576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}