nagendra,
Wednesday, March 13, 2002, 1:06:18 PM, you wrote:
np> Dear all,
np> Will MySQL supports "composite primary key" constraint? If so what
np> is the actual syntax?
Yes, MySQL supports composite primary key.
CREATE TABLE table1(
id1 int NOT NULL,
id2 int NOT NULL,
PRIMARY KEY(id1, id2));
Dear all,
Will MySQL supports "composite primary key" constraint? If so what
is the actual syntax? How foreign key relationship can be
established in MySQL? Please help me.
Prasad.
-
Before posting, please check:
http://www.