mysql 2 primary key onone table

Posted by Bharanikumar on Stack Overflow See other posts from Stack Overflow or by Bharanikumar
Published on 2010-05-18T02:42:05Z Indexed on 2010/05/18 2:50 UTC
Read the original article Hit count: 306

Filed under:
|
CREATE TABLE Orders
-> (
->    ID SMALLINT UNSIGNED NOT NULL,
->    ModelID SMALLINT UNSIGNED NOT NULL,
->    Descrip VARCHAR(40),
->    PRIMARY KEY (ID, ModelID)
-> );

Basically

May i know ...

Shall we create the two primary key on one table...

Is it correct...

Bcoz as per sql law,,,

We can create N number of unque key in one table, and only one primary key only is the LAW know...

Then how can my system allowing to create multiple primary key ?

Please advise ....

what is the general rule

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql