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
16304 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 is default schema in mysql?

970

What is a session in mysql?

1013

What is the insert?

942

What is the usage of ENUMs in MySQL?

1176

How do I copy a table in mysql?

986

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

1019

What is the datatype of image in mysql?

969

How to filter data from a mysql database table with php?

939

How many tables we can create in mysql database?

992

Is mysql free for enterprise?

949

How to shutdown mysql server?

1122

What is mysql community edition?

996

How do you know if your mysql server is alive?

1123

What is mysql database server?

1017

explain GROUPBY & HAVING clause with examples.

2326