SELECT * FROM jidlo WHERE id_kategorie = $i ORDER BY cena

INSERT INTO zamestanci (jmeno,prijemni,narozeni,plat)
VALUES ('Hugo', 'Boss', 1999, 0);

INSERT INTO zamestanci (jmeno,prijemni,narozeni,plat)
VALUES ('Diego', 'Maradona', 2000, 10);

UPDATE zamestnanci SET
id = 8,
jmeno = 'Zlatan',
prijmeni = 'Ibrahovič',
narozeni = 2004,
plat = 220000
WHERE id = 8


UPDATE zamestnanci SET
plat = 200000
WHERE id = 8;

UPDATE zamestnanci SET
plat = 1.1*plat

DELETE FROM zamestnanci 
WHERE id = 9;