What is the difference between primary and unique key

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of mysql_close()?

510


How do I assign a variable in mysql?

477


How to make a column bigger and delete unique from table.

476


Can you tell the difference between $message and $$message?

527


What is a deterministic function?

595






What is key in mysql?

497


Can you tell the difference between ereg_replace() and eregi_replace()?

526


How do I rename a mysql database?

490


What is a procedure example?

491


What is the maximum no of columns a table can have?

467


How do I download a mysql community server?

448


How do I start mysql server?

469


What are the advantages of mysql in comparison to oracle?

549


What is InnoDB?

562


What does mysql_query return?

496