mysql複数PRIMARY KEY

×ダメな例

CREATE TABLE Cars (
type NVARCHAR (36) NOT NULL,
number NVARCHAR (36) NOT NULL,
color NVARCHAR (36)
CONSTRAINT Cars_type PRIMARY KEY CLUSTERED (type ASC),
CONSTRAINT Cars_number PRIMARY KEY CLUSTERED (number ASC),
CONSTRAINT Cars_type FOREIGN KEY (type) REFERENCES Stores (identifier)
);

別々に定義してしまっている。

○良い例

CREATE TABLE Cars (
type NVARCHAR (36) NOT NULL,
number NVARCHAR (36) NOT NULL,
color NVARCHAR (36)
CONSTRAINT Cars PRIMARY KEY CLUSTERED (type ASC, number ASC),
CONSTRAINT Cars_type FOREIGN KEY (type) REFERENCES Stores (identifier)
);

一緒に定義する。