SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat desc

SELECT * FROM zamestnanci WHERE plat > 50000

SELECT * FROM zamestnanci WHERE plat < 50000 ORDER BY plat DESC

SELECT nazev, cena, id_kategorie FROM jidlo
// propojeni tabulek + alias
SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id;

INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Diego', 'Maradona', 2000, 10);

UPDATE `zamestnanci` SET
`plat` = '200000'
WHERE `id` = '8';

UPDATE zamestnanci SET
plat = 1.1*plat