mysql 2 primary key onone table
- by Bharanikumar
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