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 to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

893

what is the difference between gui testing and database testing? : Mysql dba

1075

What is normalization and list the different types of normalization?

936

What is database in php mysql?

975

How to determine the location of the data directory?

941

What is the use of procedure in mysql?

920

Is oracle better than mysql?

865

What is timestamp in mysql?

973

Why do we write stored procedures?

903

What are the security alerts while using mysql?

1020

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

997

How do you select a table?

927

How do I setup mysql?

883

how to display nth highest salary from a table in a mysql query? : Mysql dba

1049

How do I show users in mysql?

1027