Fehler bei MySQL-Syntax

Da ich noch etwas neu in SQL bin und nun mittlerweile seit heute früh um 7 in den 15 zeilen meinen Fehler suche bin ich mittlerweile am verzweifeln. Erkenntlich an den Gebissspuren in meiner Tastatur.
Irgendwo ist hier ein Fehler versteckt nur wo?

Fehler beim erstellen der Tabelle api_corp_membertracking
(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 ' `startDateTime` datetime unsigned NOT NULL, `baseID` int unsigned, ' at line 4)

    $tb_sql = array("CREATE TABLE `api_corp_membertracking`(  
    `id` int unsigned NOT NULL auto_increment,
    `characterID` int unsigned NOT NULL,
    `name` varchar,
    `startDateTime` datetime unsigned NOT NULL,
    `baseID` int unsigned,
    `base` int unsigned,
    `title` varchar,
    `logonDateTime` datetime unsigned NOT NULL,
    `logoffDateTime` datetime unsigned NOT NULL,
    `locationID` int unsigned NOT NULL,
    `location` varchar,
    `shipTypeID` int unsigned NOT NULL,
    `shipType` varchar NOT NULL,
    `roles` longint unsigned,
    `grantableRoles`int unsigned,
    PRIMARY KEY  (`id`)
    ) TYPE=MyISAM;","api_corp_membertracking");  

Please also mark the comments that contributed to the solution of the article

Content-Key: 131499

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

Printed on: April 25, 2024 at 22:04 o'clock

4 Comments

Latest comment

Ein Datemtime Feld hat keine Vorzeichenbehaftung!

`startDateTime` datetime NOT NULL,

Grüße

Max

Fehler beim erstellen der Tabelle api_corp_membertracking
(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 ' `startDateTime` datetime NOT NULL, `baseID` int unsigned, `base`' at line 4)

    $tb_sql = array("CREATE TABLE `api_corp_membertracking`(  
    `id` int unsigned NOT NULL auto_increment,
    `characterID` int unsigned NOT NULL,
    `name` varchar,
    `startDateTime` datetime NOT NULL,
    `baseID` int unsigned,
    `base` int unsigned,
    `title` varchar,
    `logonDateTime` datetime NOT NULL,
    `logoffDateTime` datetime NOT NULL,
    `locationID` int unsigned NOT NULL,
    `location` varchar,
    `shipTypeID` int unsigned NOT NULL,
    `shipType` varchar NOT NULL,
    `roles` longint unsigned,
    `grantableRoles`int unsigned,
    PRIMARY KEY  (`id`)
    ) TYPE=MyISAM;","api_corp_membertracking");  

Ein varchar erfordert eine Längenangabe:

varchar(20)

Das kannst du aber alles hier nachlesen: http://dev.mysql.com/doc/refman/5.1/de/create-table.html

danke

dachte vchar muss man nicht begrenzen, da es ja datenmenge+1bit an speicherplatz brauch

wieder eine erfahrung mehr

German closed solved Question PHP Development

Hotly discussed

Check of ZFW Firewallgleixnerd - 5 Comments