What is the diff. bwt. primary key and unique key?
- 4 Answers
- 2984 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / janhvee
diff. between primary key and unique is unique key can be
null but primary key can't be null.
one table can have only one primary key but unique key can
be multiple keys
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / rakesh ranjan
IN PRIMARY KEY IS ONLY IN ANY TABLE BUT WHEN WE TALKING
ABOUT UNIQUE KEY, IT CAN BE NULL.
| Is This Answer Correct ? | 5 Yes | 1 No |
primary is not allow null value.but unique can be allow null
value
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sonu kumar
primary of any table can't be null but unique can be
primary key may be a unique key but unique can't be a primary key b/c primary key of any relation cant be a null value
| Is This Answer Correct ? | 0 Yes | 0 No |
Use mysqldump to create a copy of the database?
How we can copy one table data into another table whose name same as table but in differ database
Explain multi-version concurrency control in MySQL?
Explain MySQL optimization?
how fastest access of data can be done from database ?
How can you plan the logshipping before processing?
How do you start MySQL on Linux?
what is collation? how many types of installations in sql server?
What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine
How can increase the performance of MySQL select query?
3 Answers Span Systems, RV Technologies,
I have two sql database at different PC.how can link b/w database and database tables.
How can we change the name of a column of a table?
Oracle 
