{"id":184,"date":"2025-05-26T12:47:50","date_gmt":"2025-05-26T10:47:50","guid":{"rendered":"https:\/\/maratsaukans23.thkit.ee\/vp\/?page_id=184"},"modified":"2025-05-27T11:37:54","modified_gmt":"2025-05-27T09:37:54","slug":"kasutajate","status":"publish","type":"page","link":"https:\/\/maratsaukans23.thkit.ee\/vp\/kasutajate\/","title":{"rendered":"kasutajad"},"content":{"rendered":"\n<p>\u00dclesanne<\/p>\n\n\n\n<p>\u25cf AB nimi \/ \u0418\u043c\u044f \u0411\u0414- kasutajaTIT\u25cf Milliseid 2 tabeli on vaja luua? \/ \u041a\u0430\u043a\u0438\u0435 2 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441\u043e\u0437\u0434\u0430\u0442\u044c? linud, mootorrattas.<\/p>\n\n\n\n<p>\u25cf Milliste tabeli v\u00e4ljadega? \/ \u0421 \u043a\u0430\u043a\u0438\u043c\u0438 \u043f\u043e\u043b\u044f\u043c\u0438? nimi, milline v\u00e4rv.<\/p>\n\n\n\n<p>\u25cf Milline on selle andmebaasi kasutaja kasutajanimi ja parool? \/\u041a\u0430\u043a\u043e\u0439 \u043b\u043e\u0433\u0438\u043d \u0438\u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u044d\u0442\u043e\u0439 \u0411\u0414? nimi-linnmoto<\/p>\n\n\n\n<p>\u25cf Millised \u00f5igused peaks kasutajal olema loodud tabelite &#8211; tabeli1 ja tabeli2 suhtes(maksimaalselt 2 \u00f5igust tabeli tasandil)? \/ \u041a\u0430\u043a\u0438\u043c\u0438 \u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u0434\u043e\u043b\u0436\u0435\u043d \u043e\u0431\u043b\u0430\u0434\u0430\u0442\u044c\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 (max 2 \u043f\u0440\u0430\u0432\u0430 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435\u0442\u0430\u0431\u043b\u0438\u0446\u044b)? mootorratas deny insert, permit select. linud permit update, deny alter<\/p>\n\n\n\n<p>\u25cf Milliseid tegevusi tuleks kontrollida? \/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u043a\u0430\u043a\u0438\u0445 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c? \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u043f\u0440\u0430\u0432.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>l\u00f5i tabeleid ja andis \u00f5igusedCREATE TABLE linud (id int primary key identity(1,1), nimi VARCHAR(20),varv VARCHAR(20) );<\/p>\n\n\n\n<p>CREATE TABLE mootorrattas ( id int primary key identity(1,1), nimi VARCHAR(20),v\u00e4rv VARCHAR(20) );<\/p>\n\n\n\n<p>Grant alter on linud TO linnmoto; Grant alter on mootorrattas TO linnmoto;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"603\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-1.png\" alt=\"\" class=\"wp-image-190\" style=\"width:391px;height:auto\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-1.png 470w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-1-234x300.png 234w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-1-300x385.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"557\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-2.png\" alt=\"\" class=\"wp-image-191\" style=\"width:392px;height:auto\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-2.png 472w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-2-254x300.png 254w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-2-300x354.png 300w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/figure>\n\n\n\n<p><strong>Lubade kontrollimine<\/strong><\/p>\n\n\n\n<p><strong>mootorrattas<\/strong><\/p>\n\n\n\n<p>insert into mootorrattas(nimi, v\u00e4rv) <\/p>\n\n\n\n<p>values (&#8216;toyota&#8217;, &#8216;must&#8217;)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"69\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-3.png\" alt=\"\" class=\"wp-image-192\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-3.png 839w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-3-300x25.png 300w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-3-768x63.png 768w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-3-624x51.png 624w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<p>select * from mootorrattas<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"521\" height=\"170\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-4.png\" alt=\"\" class=\"wp-image-193\" style=\"width:429px;height:auto\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-4.png 521w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-4-300x98.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong>Linnud<\/strong><br>UPDATE linud<\/p>\n\n\n\n<p>SET nimi = &#8216;papagoi&#8217;, varv = &#8216;punane<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"456\" height=\"137\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-5.png\" alt=\"\" class=\"wp-image-194\" style=\"width:459px;height:auto\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-5.png 456w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-5-300x90.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/figure>\n\n\n\n<p>ALTER TABLE linud<\/p>\n\n\n\n<p>ALTER COLUMN nimi VARCHAR(50);<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"743\" height=\"124\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-6.png\" alt=\"\" class=\"wp-image-195\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-6.png 743w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-6-300x50.png 300w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-6-624x104.png 624w\" sizes=\"auto, (max-width: 743px) 100vw, 743px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>XAMPP \u00f5iguste kontroll:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"733\" height=\"724\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-7.png\" alt=\"\" class=\"wp-image-196\" style=\"width:543px;height:auto\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-7.png 733w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-7-300x296.png 300w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-7-624x616.png 624w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-7-100x100.png 100w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"157\" src=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-8.png\" alt=\"\" class=\"wp-image-197\" srcset=\"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-8.png 566w, https:\/\/maratsaukans23.thkit.ee\/vp\/wp-content\/uploads\/2025\/05\/pilt-8-300x83.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u00dclesanne \u25cf AB nimi \/ \u0418\u043c\u044f \u0411\u0414- kasutajaTIT\u25cf Milliseid 2 tabeli on vaja luua? \/ \u041a\u0430\u043a\u0438\u0435 2 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441\u043e\u0437\u0434\u0430\u0442\u044c? linud, mootorrattas. \u25cf Milliste tabeli v\u00e4ljadega? \/ \u0421 \u043a\u0430\u043a\u0438\u043c\u0438 \u043f\u043e\u043b\u044f\u043c\u0438? nimi, milline v\u00e4rv. \u25cf Milline on selle andmebaasi kasutaja kasutajanimi ja parool? \/\u041a\u0430\u043a\u043e\u0439 \u043b\u043e\u0433\u0438\u043d \u0438\u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u044d\u0442\u043e\u0439 \u0411\u0414? nimi-linnmoto \u25cf Millised \u00f5igused peaks kasutajal [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-184","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/comments?post=184"}],"version-history":[{"count":3,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/184\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/pages\/184\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/maratsaukans23.thkit.ee\/vp\/wp-json\/wp\/v2\/media?parent=184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}