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




INSERT INTO zamestnanci (jmeno, prijmeni, narozeni, plat)
VALUES ('Pavel', 'Svatý', 2001, 100);



UPDATE `zamestnanci` SET
`id` = '8',
`jmeno` = 'Adam',
`prijmeni` = 'Rajský',
`narozeni` = '1999',
`plat` = '100000'
WHERE `id` = '8';



UPDATE zamestnanci SET
plat = 200000
where id = 6;



DELETE FROM `zamestnanci`
WHERE ((`id` = '9'));