CREATE TABLE nazev_tabulky
	(
	nazev_sloupce INT,
	nazev_sloupce_2 VARCHAR(10)
	);
						

ALTER TABLE nazev_tabulky
ADD COLUMN jmeno_sloupce TEXT;
						

INSERT INTO nazev_tabulky
	(sloupec1, sloupec2, sloupec3)
VALUES
	(hodnota1, hodnote2, hodnota2);
						

SELECT sloupec1, sloupec2 FROM nazev_tabulky;
						

SELECT * FROM nazev_tabulky;
						

SELECT sloupec1, sloupec2 FROM nazev_tabulky
    WHERE sloupec1 = hodnota1;
						

DROP TABLE nazev_tabulky;
						

DELETE FROM nazev_tabulky
	WHERE podminka;
						

UPDATE nazev_tabulky
	SET nazev_sloupce = hodnota
	WHERE podminka;
						

CREATE TABLE student
	(
	uco INT PRIMARY KEY,
	jmeno VARCHAR(10)
	);
						

CREATE TABLE student
	(
	uco INT PRIMARY KEY,
	rodne_cislo VARCHAR(11) NOT NULL UNIQUE,
	jmeno VARCHAR(10),
	vek INT CHECK (vek > 0)
	);
						

CREATE TABLE studenti
		( prijmeni TEXT NOT NULL,
			rocnik INT CHECK(rocnik < 6),
			vek INT,
			uco INT UNIQUE );

INSERT INTO studenti VALUES ('Kinský', 4, 25, 178);

INSERT INTO studenti VALUES ('Lobkowitz', 4, 25, 178);

INSERT INTO studenti VALUES ('Belcredi', 7, 25, 235);

INSERT INTO studenti (rocnik, vek, uco) VALUES (7,25,427);