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

9 Answers
16050 Views
Systematix, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What causes mysql too many connections?

962

What is mysql server used for?

958

What is a simple query?

911

What mysql means?

944

How can you retrieve a particular number of records from a table?

939

Is postgresql better than mysql?

1038

Where is the myisam table stored?

965

What is ntext?

1103

Can varchar be primary key?

928

What are the drivers in MySQL?

1462

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2835

Is mysql connect deprecated?

968

What are date and time functions in mysql?

1014

What can you do with mysql?

1013

How can you filter the duplicate data while retrieving records from the table?

899