What is the difference between primary and unique key
Answers were Sorted based on User's Feedback
Answer / venkat rao
Unique key takes null value but primary key doesnot take
null value
primary key have properties of both null key and unique key
constraints
| Is This Answer Correct ? | 21 Yes | 4 No |
Answer / sudhanshu_kmr
.....primary key.......... unique key
at most one column .....:... any number of column
only unique values........... only unique values
don't accept null........... accept null
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ashish asthana
Primay key restrict the duplicacy in the records and does
not accept null value or there are only one primary key in
a table
Unique constraint also restict the duplicacy but it accept
the null value one or more then one. We can apply unique
constraint more than one column
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / durai
primary key is does not allow duplicate which is contain not
null it is only once we can use in table
unique key allow null value
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pradeep rajpoot
primary key no null value allow.
but unique key one null value is allow
| Is This Answer Correct ? | 0 Yes | 4 No |
What are the similarities between a function and a procedure?
Write a query to retrieve a hundred books starting from 20th.
Is oracle better than mysql?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How do I declare a variable in mysql?
How to get the current date in mysql?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is the use of mysqli_query?
what do you mean by longblob Data type in MySql?
What is regex in mysql?
What is the usage of regular expressions in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)