SELECT * FROM tabelinimi SELECT lapsNimi, pikkus 2. lisame sorteerimine pikkuse j\u00e4rgi (max->min)<\/strong><\/p>\n\n\n\n SELECT lapsNimi, pikkus 3. n\u00e4ita lapsinimed, kes on vanem kui 10 aastat<\/strong><\/p>\n\n\n\n SELECT lapsNimi, vanus 4. n\u00e4ita lapsinimed, kellel nimi algab A t\u00e4hega<\/strong><\/p>\n\n\n\n SELECT lapsNimi 5. n\u00e4ita lapsinimed, kellel nimi algab A ja M t\u00e4hega<\/strong><\/p>\n\n\n\n SELECT lapsNimi 6. Tingimuste kombineerimine (AND, OR) SELECT lapsNimi, synnilinn, vanus 7. Uuenda tabeli andmed, k\u00f5ik lapsed vanusega 10 aastat peavad elama aadress= S\u00f5pruse pst <\/strong><\/p>\n\n\n\n UPDATE laps SET aadress=’S\u00f5pruse pst 182′ 8. Uuenda tabeli laps, nii et n\u00fc\u00fcd iga laps on 10% pikem.<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n UPDATE laps SET pikkus=pikkus*1.1; 9. BETWEEN : Otsi lapsinimed, kes on pikem kui 110 ja v\u00e4hem kui 150<\/strong><\/p>\n\n\n\n SELECT lapsNimi, pikkus SELECT lapsNimi, pikkus 10. TOP3: kolm k\u00f5ige paremad=pikemad lapsed<\/strong><\/p>\n\n\n\n SELECT lapsNimi, pikkus Iseseisvalt: lisa uus tabel loom(loomId, loomNimi, kaal, lapsID)<\/strong><\/p>\n\n\n\n CREATE TABLE loom( <\/p>\n\n\n\n kus LapsID — foreign key laps(lapsID)<\/p>\n\n\n\n Tabel loom t\u00e4ida andmetega<\/strong><\/p>\n\n\n\n CREATE TABLE loom( ALTER TABLE loom ADD CONSTRAINT laps_fk INSERT INTO loom(loomNimi, kaal, lapsID) <\/p>\n","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 SELECT lapsNimi, pikkusFROM laps 2. lisame sorteerimine pikkuse j\u00e4rgi (max->min) SELECT lapsNimi, pikkusFROM lapsORDER by pikkus DESC; 3. n\u00e4ita lapsinimed, kes on vanem kui 10 aastat SELECT lapsNimi, vanusFROM lapsWHERE vanus >=10 4. n\u00e4ita lapsinimed, kellel nimi algab A t\u00e4hega […]<\/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-377","page","type-page","status-publish","hentry"],"yoast_head":"\n
WHERE \u0443\u0441\u043b\u043e\u0432\u0438\u0435<\/strong><\/p>\n\n\n\nCREATE 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)\n<\/pre><\/div>\n\n\n
\n
FROM laps<\/p>\n\n\n\n![\"\"](\"https:\/\/merkulova.thkit.ee\/wp20\/wp-content\/uploads\/2023\/02\/image.png\")
<\/figure>\n\n\n\n
FROM laps
ORDER by pikkus DESC;<\/p>\n\n\n\n
FROM laps
WHERE vanus >=10<\/p>\n\n\n\n
FROM laps
WHERE lapsNimi LIKE ‘A%’<\/p>\n\n\n\n
FROM laps
WHERE lapsNimi LIKE ‘A%’ OR lapsNimi LIKE ‘M%’;<\/p>\n\n\n\n
N\u00e4ita k\u00f5ik lapsinimed, kes on s\u00fcndinud Tartus ja vanusega < v\u00e4hem kui 10.<\/strong><\/p>\n\n\n\n
FROM laps
WHERE synnilinn like ‘tartu’ AND vanus <10;<\/p>\n\n\n\n
WHERE vanus=10;<\/p>\n\n\n\n
select * from laps<\/p>\n\n\n\n
FROM laps
WHERE pikkus BETWEEN 110 and 150;<\/p>\n\n\n\n
FROM laps
WHERE pikkus > 110 and pikkus < 150;<\/p>\n\n\n\n
FROM laps
ORDER by pikkus DESC
LIMIT 3<\/p>\n\n\n\n
<\/p>\n\n\n\n
loomID int primary key AUTO_INCREMENT,
loomNimi varchar(25),
kaal int,
lapsID int);<\/p>\n\n\n\n
FOREIGN key (lapsID) references laps(lapsID);<\/p>\n\n\n\n
VALUES (‘kass Kilja’, 6, 2);
Select * from loom<\/p>\n\n\n\n