SELECT * FROM zamestnanci

SELECT * FROM zamestnanci 
ORDER BY plat DESC

SELECT * FROM zamestnanci
WHERE plat > 50000

// nejdriv se dava podminka, potom razeni
SELECT * FROM zamestnanci
WHERE plat < 50000
ORDER BY plat DESC

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

SELECT * FROM jidlo
WHERE nazev LIKE '%pizza%'

// novy zaznam
INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Diego', 'Maradona', 1999, 0);

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

// uprava pro vsechny zaznamy
UPDATE zamestnanci SET
plat = 1.1*plat

// smazani
DELETE FROM `zamestnanci`
WHERE id = 9;