Yes In Mysql CREATE TABLE `rooms2hire`.`user data` ( `id` INT( 11 )

is there more the two primary key in a single table?

Question Posted / abhishek chakraborty

26 Answers
31793 Views
Eforce, Systematix, I also Faced
E-Mail Answers

Answer Posted / abhishek chakraborty

Yes

In Mysql

CREATE TABLE `rooms2hire`.`user data` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`email` VARCHAR( 255 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` , `email` )
) ENGINE = MYISAM

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you explain different types of joins?

887

What is unpivot?

971

What are the different types of lock modes in sql server 2000?

884

In which tcp/ip port does sql server run? Can it be changed?

948

Can we use where clause with group by?

858

How do indexes help, types?

910

What is resource governor in sql server?

949

Why is sql server log file full?

979

Explain the difference between function and stored procedure?

900

What is deploy, process and build? : sql server analysis services, ssas

1036

Can we write a distributed query and get some data which is located on other server and oracle database?

1178

Is it possible in sql table to have more than one foreign key?

980

Mention the different types of replication in sql server.

962

Can foreign key be duplicate?

1002

What is a functions and types in sql server?

1012