{"id":559,"date":"2023-02-09T10:43:21","date_gmt":"2023-02-09T08:43:21","guid":{"rendered":"https:\/\/portfoolio403336508.wordpress.com\/?page_id=559"},"modified":"2023-02-09T10:43:21","modified_gmt":"2023-02-09T08:43:21","slug":"select-laused","status":"publish","type":"page","link":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/select-laused\/","title":{"rendered":"SELECT laused"},"content":{"rendered":"

\u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/p>\n\n\n\n

SELECT * from tabelinimi<\/strong><\/p>\n\n\n\n

SELECT * from tabelinimi<\/strong>
WHERE \u0443\u0441\u043b\u043e\u0432\u0438\u0435<\/p>\n\n\n\n

CREATE TABLE laps(\n    lapsID int not null PRIMARY KEY AUTO_INCREMENT,\n    lapsNimi varchar(20) not null,\n    vanus int,\n    synnilinn varchar(25),\n    pikkus int,\n    aadress text)<\/pre>\n\n\n\n
INSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Anna', 7, 100, 'Tartu');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Aleks', 9, 101, 'Narva');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Kent', 12, 114, 'Tallinn');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Stefan', 11, 116, 'Rapla');\nselect * FROM laps<\/pre>\n\n\n\n
INSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Anna', 7, 100, 'Tartu');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Aleks', 9, 101, 'Narva');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Kent', 12, 114, 'Tallinn');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Stefan', 11, 116, 'Rapla');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Sveta', 16, 168, 'Narva');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Risto', 18, 196, 'Tallinn');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Sass', 17, 115, 'Tartu');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Miia', 17, 156, 'Rapla');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Ekaterina', 11, 117, 'Rapla');\nINSERT INTO laps(lapsNimi, vanus, pikkus, synnilinn)\nVALUES ('Stefania', 6, 113, 'Tallinn');\nselect * FROM laps\n<\/pre>\n\n\n\n
N\u00e4ita tabelist kaks veergu nimi
N\u00e4ita lapsenimed kui on vanem kui 10 aastat 
N\u00e4ita lapsenimed kellel nime algab A t\u00e4hega
N\u00e4ita lapsenimed kelle nimi algab A ja M t\u00e4hega
Tingimuste kombineerimine (AND, OR). N\u00e4ita k\u00f5ik lapsinimem, kes on s\u00fcndinud Tartus ja vanusega < v\u00e4hem kui 10
Uuenda tabeli andmed, k\u00f5ik lapsed vanusega 11 aastat peavad elama addressil S\u00f5pruse pst
Uuenda tabeli laps, nii et iga laps on 10% pikkem
TOP3 k\u00f5ige paremad=pikemad lapsed
Lisa uus tabel loom(loomid, loomnimi, kaal, lapsid)<\/p>\n\n\n\n
SELECT lapsNimi, pikkus\nFROM laps<\/pre>\n\n\n\n
select lapsNimi, pikkus\nFROM laps \nORDER BY pikkus DESC;<\/pre>\n\n\n\n
\"\"<\/figure>
\n
sorteerimine<\/p>\n<\/div><\/div>\n\n\n\n
select lapsNimi, vanus\nFROM laps \nWHERE vanus >=10<\/pre>\n\n\n\n
select lapsNimi\nFROM laps \nWHERE lapsnimi LIKE 'A%'<\/pre>\n\n\n\n
select lapsNimi\nFROM laps \nWHERE lapsnimi LIKE 'A%' OR lapsNimi LIKE 'M%'<\/pre>\n\n\n\n
select lapsNimi, synnilinn, vanus\nFROM laps \nWHERE synnilinn LIKE 'tartu' AND vanus <10<\/pre>\n\n\n\n
UPDATE laps SET aadress='S\u00f5pruse pst 182'\nWHERE vanus=11;\nSELECT * FROM laps <\/pre>\n\n\n\n
UPDATE laps SET pikkus=pikkus*1.1;\nSELECT * FROM laps \n<\/pre>\n\n\n\n
SELECT lapsNimi, pikkus\nFROM laps \nWHERE pikkus BETWEEN 110 AND 150;\n\nSELECT lapsNimi, pikkus\nFROM laps \nWHERE pikkus > 110 and pikkus <150;<\/pre>\n\n\n\n
SELECT lapsNimi, pikkus\nFROM laps \nORDER BY pikkus DESC\nLIMIT 3<\/pre>\n\n\n\n
ALTER TABLE loom ADD CONSTRAINT laps_fk \nFOREIGN KEY (lapsID) references laps(lapsID);\n\nINSERT INTO loom(loomNimi, kaal, lapsID)\nVALUES ('kass Kilja', 6, 2);\nINSERT INTO loom(loomNimi, kaal, lapsID)\nVALUES ('kass Ninja', 3, 4);\nINSERT INTO loom(loomNimi, kaal, lapsID)\nVALUES ('koer Naqalengelo', 11, 4);\nINSERT INTO loom(loomNimi, kaal, lapsID)\nVALUES ('kala Oskar', 1, 6);\nINSERT INTO loom(loomNimi, kaal, lapsID)\nVALUES ('koer Nik', 16, 8);\nSELECT * from loom\n    <\/pre>\n\n\n\n
iseseisev t\u00f6\u00f6
<\/h2>\n\n\n\n
CREATE TABLE auto(\n    autoID int not null PRIMARY KEY AUTO_INCREMENT,\n    mark varchar(20) not null,\n    regnr varchar(7) not null,\n    aasta int,\n    regPiirk int)<\/pre>\n\n\n\n
INSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Audi', 123 ABC, 2001, 1);\nINSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Ford', 777 AAA, 1988, 2);\nINSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Ford', FIN 772, 2002, 1);\nINSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Nisan', 111 CCC, 2006, 1);\nINSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Toyota', 128 HGF, 2001, 1);\nINSERT INTO auto(mark, regNr, aasta, regPiirk)\nVALUES ('Vaz', 544 CCH, 1960, 2);<\/pre>","protected":false},"excerpt":{"rendered":"
\u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b SELECT * from tabelinimi SELECT * from tabelinimiWHERE \u0443\u0441\u043b\u043e\u0432\u0438\u0435 N\u00e4ita tabelist kaks veergu nimiN\u00e4ita lapsenimed kui on vanem kui 10 aastat N\u00e4ita lapsenimed kellel nime algab A t\u00e4hegaN\u00e4ita lapsenimed kelle nimi algab A ja M t\u00e4hegaTingimuste kombineerimine (AND, OR). N\u00e4ita k\u00f5ik lapsinimem, kes on s\u00fcndinud Tartus ja vanusega < […]<\/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-559","page","type-page","status-publish","hentry"],"yoast_head":"\nSELECT laused - Veronika Milovzorova portfolio\/ est<\/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:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/select-laused\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SELECT laused - Veronika Milovzorova portfolio\/ est\" \/>\n<meta property=\"og:description\" content=\"\u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b SELECT * from tabelinimi SELECT * from tabelinimiWHERE \u0443\u0441\u043b\u043e\u0432\u0438\u0435 N\u00e4ita tabelist kaks veergu nimiN\u00e4ita lapsenimed kui on vanem kui 10 aastat N\u00e4ita lapsenimed kellel nime algab A t\u00e4hegaN\u00e4ita lapsenimed kelle nimi algab A ja M t\u00e4hegaTingimuste kombineerimine (AND, OR). N\u00e4ita k\u00f5ik lapsinimem, kes on s\u00fcndinud Tartus ja vanusega < […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/select-laused\/\" \/>\n<meta property=\"og:site_name\" content=\"Veronika Milovzorova portfolio\/ est\" \/>\n<meta property=\"og:image\" content=\"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/wp-content\/uploads\/2023\/02\/hoiva-1.png?w=436\" \/>\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 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/\",\"url\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/\",\"name\":\"SELECT laused - Veronika Milovzorova portfolio\\\/ est\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/hoiva-1.png?w=436\",\"datePublished\":\"2023-02-09T08:43:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/#primaryimage\",\"url\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/hoiva-1.png?w=436\",\"contentUrl\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/hoiva-1.png?w=436\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/select-laused\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SELECT laused\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/\",\"name\":\"Veronika Milovzorova portfolio\\\/ est\",\"description\":\"Noorem Tarkvaraarendaja\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/veronikamilovzorova22.thkit.ee\\\/wp\\\/?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":"SELECT laused - Veronika Milovzorova portfolio\/ est","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:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/select-laused\/","og_locale":"en_US","og_type":"article","og_title":"SELECT laused - Veronika Milovzorova portfolio\/ est","og_description":"\u0437\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b SELECT * from tabelinimi SELECT * from tabelinimiWHERE \u0443\u0441\u043b\u043e\u0432\u0438\u0435 N\u00e4ita tabelist kaks veergu nimiN\u00e4ita lapsenimed kui on vanem kui 10 aastat N\u00e4ita lapsenimed kellel nime algab A t\u00e4hegaN\u00e4ita lapsenimed kelle nimi algab A ja M t\u00e4hegaTingimuste kombineerimine (AND, OR). N\u00e4ita k\u00f5ik lapsinimem, kes on s\u00fcndinud Tartus ja vanusega < […]","og_url":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/select-laused\/","og_site_name":"Veronika Milovzorova portfolio\/ est","og_image":[{"url":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/wp-content\/uploads\/2023\/02\/hoiva-1.png?w=436","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/","url":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/","name":"SELECT laused - Veronika Milovzorova portfolio\/ est","isPartOf":{"@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/#primaryimage"},"image":{"@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/#primaryimage"},"thumbnailUrl":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/wp-content\/uploads\/2023\/02\/hoiva-1.png?w=436","datePublished":"2023-02-09T08:43:21+00:00","breadcrumb":{"@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/#primaryimage","url":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/wp-content\/uploads\/2023\/02\/hoiva-1.png?w=436","contentUrl":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/wp-content\/uploads\/2023\/02\/hoiva-1.png?w=436"},{"@type":"BreadcrumbList","@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/select-laused\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"SELECT laused"}]},{"@type":"WebSite","@id":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/#website","url":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/","name":"Veronika Milovzorova portfolio\/ eng","description":"junior software developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/pages\/559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/comments?post=559"}],"version-history":[{"count":0,"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/pages\/559\/revisions"}],"wp:attachment":[{"href":"https:\/\/veronikamilovzorova22.thkit.ee\/wp\/en\/wp-json\/wp\/v2\/media?parent=559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}