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

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

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

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

Answer / pradeep rajpoot

primary key no null value allow.
but unique key one null value is allow

What is the maximum size of table in mysql?

0 Answers  

What is the difference between char and varchar in mysql?

0 Answers  

what is the querry for all managers salary?

2 Answers  

Why we use mongodb instead of mysql?

0 Answers  

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 Answers  

What are features of mysql?

0 Answers  

Where is mysql used?

0 Answers  

Write a command with which mysql table can be repaired

0 Answers  

How to dump a table from a database.

0 Answers  

What is row locking in mysql?

0 Answers  

Use mysqldump to create a copy of the database?

2 Answers  

Can you tell what are various ways to create an index?

0 Answers