🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.lang.php
Article #231389

Re: dziwne wyniki zapytania SQL

#231389
From: Jivanmukta
Date: Fri, 08 Jul 2016 09:01
64 lines
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-mail
References: <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