Не могу создать таблицу опять (

Question

CREATE TABLE Investments
(
    IDInvestment INT NOT NULL AUTO_INCREMENT,
    AccountNumber INT NOT NULL,
    Type VARCHAR (7) NOT NULL,
    InvSum INT,
    Per_Cents FLOAT NOT NULL,
    Currency VARCHAR (6) NOT NULL, 
    OpenningDate DATETIME,
    PasportSN CHAR (11) NOT NULL,
            UNIQUE (AccountNumber),
    FOREIGN KEY (PasportSN) REFERENCES Investors(PasportSN)
)

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

Answer 1

Добавте Primary Key

CREATE TABLE Investments
(
    IDInvestment INT AUTO_INCREMENT PRIMARY KEY,
    AccountNumber INT NOT NULL,
    Type VARCHAR (7) NOT NULL,
    InvSum INT,
    Per_Cents FLOAT NOT NULL,
    Currency VARCHAR (6) NOT NULL, 
    OpenningDate DATETIME,
    PasportSN CHAR (11) NOT NULL,
            UNIQUE (AccountNumber),
    FOREIGN KEY (PasportSN) REFERENCES Investors(PasportSN)
)

БЛОГ НА HUSL

Не могу создать таблицу опять (

Ответы (1 шт):