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

What is action query?

949

What is the difference between truncate and delete?

1272

How do I find mysql version in mysql workbench?

997

Why does mysql have so many connections?

947

Can we rollback truncate in mysql?

1062

Explain timestamp?

1020

How you can create a trigger in mysql?

1059

How do I start mysql database?

1030

What is sql vs mysql?

1073

How do I make an action query?

995

What is sql in mysql?

1089

How to display nth highest salary from a table in a mysql query?

1051

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

984

What, if a table has one column defined as TIMESTAMP?

1079

What's new in mysql 8?

1045