SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY plat DESC

SELECT * FROM zamestnanci WHERE plat > 50000

SELECT * FROM zamestnanci WHERE plat < 50000

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


//novy zaznam
INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Hugo', 'Boss', 2000, 10);

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

DELETE FROM zamestnanci
WHERE id = 9;