is there more the two primary key in a single table?
- 26 Answers
- 26018 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
What is sql server query analyzer?
What is report snapshot in ssrs?
Explain full-text query in sql server?
Can You Use Data Mining Models In Ssrs?
What type of locking occurs during the snapshot generation? : sql server replication
What is database mirroring?
What are the types of indexes?
What is the difference between a fill factor of 100 and 0?
What does it mean to be in union?
What are the restraints imposed on the table design by a merge replication?
What are the differences between ms sql server & oracle?
What are the differences between char and nchar in ms sql server?
What stored procedure can you use to display the current processes?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are sparse columns?
