SELECT * FROM gielda_kody_rodzaj INNER JOIN gielda_kody_oferty ON gielda_kody_rodzaj.id = gielda_kody_oferty.rodzaj
id select_type TABLE type possible_keys KEY key_len ref rows Extra
1 SIMPLE gielda_kody_oferty ALL NULL NULL NULL NULL 90265
1 SIMPLE gielda_kody_rodzaj eq_ref PRIMARY PRIMARY 4 gielda.gielda_kody_oferty.rodzaj 1
gielda_kody_rodzaj CREATE TABLE `gielda_kody_rodzaj` (\n `id` int(8) NOT NULL AUTO_INCREMENT,\n `nazwa` varchar(128) character SET utf8 collate utf8_polish_ci NOT NULL,\n `min` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n `max` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n `prefix` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n `www` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n `admin` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=latin2
gielda_kody_oferty CREATE TABLE `gielda_kody_oferty` (\n `id` int(8) NOT NULL AUTO_INCREMENT,\n `rodzaj` int(128) NOT NULL,\n `cena` decimal(65,2) NOT NULL,\n `nick` varchar(255) character SET utf8 collate utf8_polish_ci NOT NULL,\n `data` datetime NOT NULL,\n `kod` varchar(255) NOT NULL,\n `admin` varchar(255) NOT NULL,\n `stat` int(1) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM AUTO_INCREMENT=116612 DEFAULT CHARSET=latin2