CREATE TABLE Test (id1 INT ,id2 INT , name CHAR(20) NOT NULL, PRIMARY KEY(

how we can use more then one primary key in Single Table

Question Posted / sharad

Answer Posted / sharad

CREATE TABLE Test (id1 INT ,id2 INT , name CHAR(20) NOT
NULL, PRIMARY KEY(id1,id2));

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How is data stored in mysql?

868

What are different types of queries?

899

What is mysql connector used for?

880

What is 1nf 2nf 3nf?

913

List some mysql advantages and disadvantages?

908

How large can a mysql table be?

883

What are the 3 main types of search queries?

784

What is orm in mysql?

850

Is mysql better than oracle?

871

Explain about the architecture of MYSQL?

928

How to get a list of all tables in a database?

1002

What are the disadvantages of mysql?

1006

Explain the different types of constraints?

882

Can we save images in mysql database?

845

How do I check mysql version?

956