MySQL-Verstehe Fehler nicht

[Reality]

Hallo,

hab bei folgenden Befehlen:

CREATE TABLE IF NOT EXISTS CommandSet (CommandSet.ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, FirmwareApplicName VARCHAR(25), Version VARCHAR(10), PRIMARY KEY (CommandSet.ID));

CREATE TABLE IF NOT EXISTS Command (Command.ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, Command VARCHAR(100), DocText TEXT, CommandSet.ID BIGINT, PRIMARY KEY (Command.ID), FOREIGN KEY CommandSet.ID REFERENCES CommandSet (CommandSet.ID) );

folgenden Fehler:

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)); CREATE TABLE IF NOT EXISTS Command(Command.ID BIGINT N

Kann aber aus der SQL-Referenz auch nix rauslesen, was da falsch sein sollte, vielleicht kann mir jemand von euch helfen. Bitte bitte

Mfg,

Reality

[TimeOut]

CREATE TABLE IF NOT EXISTS CommandSet (CommandSet.ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, FirmwareApplicName VARCHAR(25), Version VARCHAR(10), PRIMARY KEY (CommandSet.ID));

CREATE TABLE IF NOT EXISTS Command (Command.ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, Command VARCHAR(100), DocText TEXT, CommandSet.ID BIGINT, PRIMARY KEY (Command.ID), FOREIGN KEY CommandSet.ID REFERENCES CommandSet (CommandSet.ID) );

Warum referenzierst du bei der Spaltenerstellung die (noch nicht erstellte) Tabelle?

Wenn du das folgendermassen machst, klappt alles:

CREATE TABLE IF NOT EXISTS CommandSet (ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, FirmwareApplicName VARCHAR(25), Version VARCHAR(10), PRIMARY KEY (ID));

CREATE TABLE IF NOT EXISTS Command (ID BIGINT NOT NULL AUTO_INCREMENT UNIQUE, PRIMARY KEY (ID), Command VARCHAR(100), DocText TEXT, CommandSet_ID BIGINT, FOREIGN KEY (CommandSet_ID) REFERENCES CommandSet(ID) );

Quellen:

http://dev.mysql.com/doc/refman/5.0/en/create-table.html

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html