Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 32665 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
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is data modeling and Reterminal integrity?
What is the difference between join and inner join?
What is normalization and its types?
What is recompile sql server?
What stored by the master?
What is the difference between truncate and delete commands?
How to Sync Two SQL Azure Databases?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to connect of datebase with sql express.?
Do you know what is lock escalation?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are date and time data types in ms sql server?
what are constraints? : Sql server database administration
What is policy management?
