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
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