🚀 go-pugleaf

Dnia Mon, 28 Aug 2017 16:56:39 +0200, od Jivanmukta
<jivanmukta@poczta.onet.pl> nadeszla wiadomosc:

>Polecenie: mysql -u root -p baza76_rozgloszenia <etv.txt
>zwraca mi b³±d:
>ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
>check the manual that corresponds to your MariaDB server version for the
>right syntax to use near '+' COMMENT 'Widocznosc pola powierzchni
>dzialki',use_area_parcel_minus varchar(1' at line 1
>Nie widzê co jest ¼le w pliku etv.txt, oto on (zawiera jeden wiersz):
>
>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_postal_code
>varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT '+' COMMENT 'Widocznosc
>kodu pocztowego',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_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_places varchar(10) COLLATE
>utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola liczby
>lokali',use_area_offices varchar(11) COLLATE utf8_polish_ci NOT NULL
>DEFAULT '+' COMMENT 'Widocznosc pola powierzchni pomieszczen',use_parcel
>varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT '+' COMMENT

--------------------------------------------------------------
>'Widocznosc pola dziaki,use_area_parcel varchar(11) COLLATE
-------------------------------------------------------------

O, to mi siê nie podoba...



>utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola powierzchni
>dzialki',use_area_parcel_minus varchar(11) COLLATE utf8_polish_ci NOT
>NULL DEFAULT '+' COMMENT 'Widocznosc pola powierzchni dzialki minus
>zabudowania',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 wlasnosci',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_basement varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT
>'+' COMMENT 'Widocznosc pola piwnica',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 pradu',use_sewerage varchar(1) COLLATE
>utf8_polish_ci NOT NULL DEFAULT '+' COMMENT 'Widocznosc pola
>kanalizacji',use_cess varchar(1) COLLATE utf8_polish_ci NOT NULL DEFAULT
>'+' COMMENT 'Widocznosc pola szambo',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';
>
>Je¶li kto¶ widzi, to proszê mi wskazaæ.

Slawek Maculewicz wrote:
>>'Widocznosc pola dziaki,use_area_parcel varchar(11) COLLATE
> -------------------------------------------------------------
>
> O, to mi się nie podoba...

Wielkie dzieki!