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

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