Composite primary key in MySQL

2002-03-13 Thread Victoria Reznichenko
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));

Composite primary key in MySQL

2002-03-13 Thread nagendra prasad
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.