SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY prijmeni

SELECT * FROM zamestnanci ORDER BY prijmeni DESC

SELECT * FROM zamestnanci WHERE id > 2

SELECT * FROM zamestnanci WHERE id > 2 ORDER BY prijmeni


SELECT * FROM jidlo
INNER JOIN kategorie
ON jidlo.id_kategorie = kategorie.id
ORDER BY cena


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

SELECT * FROM jidlo
WHERE nazev LIKE 'P%'

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

INSERT INTO `zamestnanci` (`jmeno`, `prijmeni`, `narozeni`, `plat`)
VALUES ('da', 'da', '54', '54');

INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('da', 'da', '54', '54');

UPDATE zamestnanci SET
id = '6',
jmeno = 'Adam',
prijmeni = 'david',
narozeni = '2054',
plat = '59'
WHERE id = '6';

DELETE FROM zamestnanci WHERE id = 8;