Ultimate Datenbank Fehler

Fehler
SQL-Befehl:


CREATE TABLE IF NOT EXISTS  `carhouses_icons` (


 `Name` VARCHAR( 50 ) NOT NULL ,
 `ID` INT( 3 ) NOT NULL ,
 `X` DOUBLE NOT NULL ,
 `Y` DOUBLE NOT NULL ,
 `Z` DOUBLE NOT NULL ,
 `SpawnX` FLOAT NOT NULL ,
 `SpawnY` FLOAT NOT NULL ,
 `SpawnZ` FLOAT NOT NULL ,
 `SpawnRX` FLOAT NOT NULL ,
 `SpawnRY` FLOAT NOT NULL ,
 `SpawnRZ` FLOAT NOT NULL ,
PRIMARY KEY (  `ID` )
) ENGINE = MYISAM DEFAULT AUTO_INCREMENT =12 CHARSET = latin1;


MySQL meldet: Dokumentation


#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 'AUTO_INCREMENT=12 CHARSET=latin1' at line 26