What is the difference between primary and unique key

Answer Posted / pradeep rajpoot

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

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to represent ENUMs and SETs internally?

637


How to return query output in xml format?

590


What is a result set object?

521


What are the other commands to know the structure of a table using mysql commands except explain command?

538


What is difference between oracle and mysql?

492






How can you change the password of a mysql user?

495


What is difference between oracle sql and mysql?

491


Is mysql server free?

485


What language is used in mysql?

507


How to Join tables on common columns.

639


How to escape special characters in sql statements?

525


What is dbms in mysql?

502


How many primary keys can be there in a table?

531


How do I quit mysql?

485


How can I change database in mysql?

452