jf1mSHYK

1CREATE TABLE IF NOT EXISTS `staty` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `zkratka` char(2)   CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL, 
4  `nazev` varchar(50) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;  
7
8insert into staty
9
10insert into staty3 (zkratka, nazev)
11select stat, if(stat="CZ", "Česká republika", "Slovensko") from uzivatele group by stat order by stat
12insert into staty3 (zkratka, nazev) values ("DE", "Německo"), ("AT", "Rakousko");