primary key

[kcatton]

If you have two columns in a database table and you want the primary key to be both of them ie. a composite key because this is only way to make it unique - how do you set this up when you create the table.
Mysql won't let you nominate them both as primary keys so what do you do.

Kerrilyn

[freakysid]

eg:

CREATE TABLE Foo(
bar INT NOT NULL,
zoot CHAR(8),
PRIMARY KEY (bar, zoot)
);