--- INDEXY ----- tvorba tabulky

create table studenti3 (`jmeno` varchar (50), `prezdivka` varchar(50), index (prezdivka));

create table studenti2 (`jmeno` varchar (50), `prezdivka` varchar(50), unique (prezdivka));



--- INDEXY ----- do hotové tabulky

ALTER TABLE studenti add index (mesto);

ALTER TABLE studenti add unique (datum_narozeni)

--- INDEXY ----- smazat

ALTER TABLE studenti drop index mesto; 

ALTER TABLE studenti drop index datum_narozeni;