Article View: pl.comp.lang.php
Article #231389Re: dziwne wyniki zapytania SQL
From: Jivanmukta
Date: Fri, 08 Jul 2016 09:01
Date: Fri, 08 Jul 2016 09:01
64 lines
4123 bytes
4123 bytes
Dodam, że: PHP Version 5.5.9-1ubuntu4.13 mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.3 CREATE TABLE `estate_types_visibility` ( `estate_type_id` varchar(5) COLLATE utf8_polish_ci NOT NULL COMMENT 'Identyfikator rodzaju nieruchomosci', `use_region` varchar(2) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola wojewodztwa', `use_town` varchar(25) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola miejscowosci', `use_district` varchar(25) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola dzielnicy', `use_address` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola adresu', `use_floor_no` varchar(5) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola numeru pietra', `use_floors` varchar(5) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola liczby pieter', `use_area` varchar(11) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola powierzchni', `use_rooms` varchar(10) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola liczby pokoi', `use_offices` varchar(10) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola liczby pomieszczen', `use_year_built` varchar(5) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola roku budowy', `use_ownership` varchar(3) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola formy wlasnoĂĹci', `use_standard` varchar(2) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola standardu', `use_house` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola domka letniskowego', `use_buildings` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola zabudowan', `use_garrage` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola garazu', `use_parking` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola miejsca parkingowego', `use_kitchen` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola widnej kuchni', `use_balcony` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola balkonu', `use_gas` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola gazu', `use_current` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola prĂÄdu', `use_sewerage` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola kanalizacji', `use_furniture_type` varchar(3) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pol umeblowania', `use_equipment` varchar(8) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pol wyposazenia', `use_guard` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola ochrony', `use_pictures` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pol zdjec / filmow', `use_remarks` varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola dodatkowego opisu', PRIMARY KEY (`estate_type_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci COMMENT='Widocznosc pol zaleznych od rodzaju nieruchomosci';
Technical Details
Message-ID:
<nlnq4n$g3l$1@gioia.aioe.org>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!aioe.org!.POSTED!not-for-mailReferences:
<1ee1eacf-a3bc-4626-bac3-53f8af2dd405@googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!aioe.org!.POSTED!not-for-mail From: Jivanmukta <jivanmukta@poczta.onet.pl> Newsgroups: pl.comp.lang.php Subject: Re: dziwne wyniki zapytania SQL Date: Fri, 08 Jul 2016 11:01:11 +0200 Organization: Aioe.org NNTP Server Lines: 66 Message-ID: <nlnq4n$g3l$1@gioia.aioe.org> References: <1ee1eacf-a3bc-4626-bac3-53f8af2dd405@googlegroups.com> NNTP-Posting-Host: 4V1s6eib8XHR2ECYDUb82Q.user.gioia.aioe.org Mime-Version: 1.0 X-Complaints-To: abuse@aioe.org User-Agent: KNode/4.14.2 X-Notice: Filtered by postfilter v. 0.8.2 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit