wpforge
Goto Top

MYSQL Tabelle lässt sich nicht erstellen

Moin,

Ich versuche eine Mysql Tabelle zu erstellen.
create table `haus_kauf`
  {
  `id` BIGINT auto_increment,
  `beschreibung` LONGTEXT null,
  `ausstattung` LONGTEXT null,
  `lage` LONGTEXT null,
  `sonstiges` LONGTEXT null,
  `firstSeen` DATE null,
  `removed` DATE null,
  `obj_regio1` VARCHAR(255) null,
  `obj_heatingType` VARCHAR(255) null,
  `obj_telekomTvOffer` VARCHAR(255) null,
  `obj_cId` BIGINT null,
  `obj_newlyConst` TINYINT null,
  `obj_balcony` TINYINT null,
  `obj_picture` VARCHAR(255) null,
  `obj_electricityBasePrice` DOUBLE null,
  `obj_picturecount` BIGINT null,
  `obj_pricetrend` DOUBLE null,
  `obj_telekomUploadSpeed` VARCHAR(255) null,
  `obj_telekomTrackingGroup` VARCHAR(255) null,
  `obj_telekomInternetTechnology` VARCHAR(255) null,
  `obj_yearConstructed` BIGINT null,
  `obj_telekomInternetType` VARCHAR(255) null,
  `obj_galleryAd` TINYINT null,
  `obj_electricityKwhPrice` DOUBLE null,
  `ga_cd_test_cxp_ads` VARCHAR(255) null,
  `obj_dfpZipCodeCluster` VARCHAR(255) null,
  `obj_pricetrendbuy` DOUBLE null,
  `obj_scoutId` BIGINT null,
  `obj_noParkSpaces` VARCHAR(255) null,
  `obj_hasKitchen` TINYINT null,
  `obj_ExclusiveExpose` TINYINT null,
  `obj_telekomInternetProductName` VARCHAR(255) null,
  `geo_bln` VARCHAR(255) null,
  `obj_cellar` TINYINT null,
  `obj_yearConstructedRange` BIGINT null,
  `obj_houseNumber` VARCHAR(255) null,
  `obj_pricetrendrent` DOUBLE null,
  `obj_livingSpace` DOUBLE null,
  `geo_krs` VARCHAR(255) null,
  `obj_zipCode` BIGINT null,
  `obj_condition` VARCHAR(255) null,
  `ga_cd_test_cxp_expose_widgets` VARCHAR(255) null,
  `obj_interiorQual` VARCHAR(255) null,
  `ga_cd_cxp_historicallisting` TINYINT null,
  `obj_telekomDownloadSpeed` VARCHAR(255) null,
  `obj_street` VARCHAR(255) null,
  `obj_lift` TINYINT null,
  `obj_telekomInternetUrlMobile` VARCHAR(255) null,
  `obj_telekomInternetUrl` VARCHAR(255) null,
  `obj_streetPlain` VARCHAR(255) null,
  `obj_typeOfFlat` VARCHAR(255) null,
  `geo_plz` BIGINT null,
  `obj_noRooms` DOUBLE null,
  `obj_assistedLiving` TINYINT null,
  `obj_ityp` VARCHAR(255) null,
  `obj_telekomHdTelephone` TINYINT null,
  `geo_land` VARCHAR(255) null,
  `ga_cd_via` VARCHAR(255) null,
  `obj_telekomInternet` VARCHAR(255) null,
  `obj_immotype` VARCHAR(255) null,
  `ga_cd_test_cxp_expose_contact_flow` VARCHAR(255) null,
  `obj_floor` BIGINT null,
  `obj_telekomInternetServices` VARCHAR(255) null,
  `obj_telekomInternetProductAvailable` TINYINT null,
  `obj_cwId` VARCHAR(255) null,
  `ga_cd_test_cxp_expose` VARCHAR(255) null,
  `ga_cd_application_requirements` VARCHAR(255) null,
  `obj_numberOfFloors` DOUBLE null,
  `obj_noRoomsRange` BIGINT null,
  `ga_cd_maillead_default_shown` TINYINT null,
  `obj_garden` TINYINT null,
  `obj_barrierFree` TINYINT null,
  `obj_regio3` VARCHAR(255) null,
  `obj_objectnumber` VARCHAR(255) null,
  `obj_livingSpaceRange` BIGINT null,
  `obj_regio2` VARCHAR(255) null,
  `obj_courtage` TINYINT null,
  `obj_purchasePriceRange` BIGINT null,
  `obj_groupnumber` BIGINT null,
  `obj_rented` TINYINT null,
  `obj_purchasePrice` BIGINT null,
  `obj_international` TINYINT null,
  `obj_usableArea` BIGINT null,
  `ga_cd_developer_virtualreality` TINYINT null,
  constraint haus_kauf_pk
  primary key (id)
  );

Folgenden Fehler bekomme ich:
[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ `id` BIGINT auto_increment, `beschreibung` LONGTEXT null, `ausstattun' at line 2


Nun finde ich eigentlich, dass der Befehl, besonders da oben, gut aussieht.

Mag mir jemand den Wald zeigen, den ich offensichtlich vor lauter bäumen nicht sehe ? ;)

Content-Key: 400004

Url: https://administrator.de/contentid/400004

Printed on: April 23, 2024 at 08:04 o'clock

Member: sabines
Solution sabines Jan 31, 2019 at 11:57:35 (UTC)
Goto Top
Moin,

bist Du Dir mit den Hochkommata sicher?
Ich kenn' das so:

CREATE TABLE TEST1 (
id132 INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
NAME VARCHAR(30) NOT NULL,
TEST VARCHAR(50))
 
Member: WPFORGE
WPFORGE Jan 31, 2019 at 12:21:04 (UTC)
Goto Top
Ich habs gefunden.
Die Hochkommate gehören weg und die erste klammer ist keine geschweifte ;)