SELECT * FROM zamestnanci


SELECT * FROM zamestnanci
ORDER BY plat DESC

SELECT * FROM zamestnanci
WHERE plat > 50000


PropojenĂ­ tabulek, alias
    SELECT jidlo.nazev, cena, kategorie.nazev AS kategorie
    FROM jidlo
    INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id

Výběr přes jméno položky
    SELECT * FROM jidlo
    WHERE nazev LIKE "%pizza%"

VloĹľenĂ­ do tabulky
    INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
    VALUES ('Michel', 'Jordin', '1986', '1698754');

Update hodnoty
    UPDATE zamestnanci SET narozeni = 1981 WHERE id = 8;

    DELETE FROM zamestnanci
    WHERE id = 9;