What is the difference between primary and unique key

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database in php mysql?

491


Write a query to create a database and a table?

489


Is mysql relational?

507


How can you create and drop view in mysql?

505


What is indexing in mysql?

459






how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1804


What is different between sql and mysql?

504


write a query to mysql in safe mode and to change the root password

516


How do I copy a table in mysql?

484


Write a query to fetch duplicate records from a table using mysql?

501


can you tell what are the different set operations available in mysql? : Mysql dba

508


what is the difference between between and in operators in mysql?

496


Do I need to pay for mysql?

489


What is delimiter in mysql stored procedure?

475


What is back end and front end?

463