CREATE TABLE people (id INTEGER PRIMARY KEY, first_name TEXT, last_name TEXT, age INTEGER, gender TEXT); <===> takto se vepisuji udaje do tabulky
SELECT * FROM people; <===> vypise vsechny lidi
SELECT * FROM people ORDER BY age ASC; <===> vypise vsechny lidi, seradi je dle prijmeni (sestupne)
SELECT * FROM people ORDER BY last_name DESC; <===> vypise vsechny lidi, seradi je dle prijmeni (vzestupne)
SELECT * FROM people WHERE age=22; <===> vypise vsechny lidi, kterym je 22 let
SELECT first_name, age FROM people WHERE age BETWEEN 30 AND 50; <===> vypise vsechny lidi (jejich krestni jmeno a vek), kterym je mezi 30 a 50 lety
DELETE FROM people WHERE id=5; <===> smaze zaznam s cislem ID 5
SELECT * FROM customers WHERE Country="USA" ORDER BY City ASC;
#<------------------------------------ ------------------------------------>#
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Petr", "Novotny", 50, "m");
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Jana", "Zelena", 22, "z");
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Roman", "Toman", 42, "m");
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Karel", "Ctvrty", 67, "m");
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Hana", "Ostra", 66, "z");
INSERT INTO people (first_name, last_name, age, gender) VALUES ("Ludek", "Peprny", 22, "m");
MariaDB
sudo apt-get install mariadb-server <===> nainstaluje server MariaDB