What is the difference between primary and unique key

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a new database in mysql?

476


What is mysql uuid?

526


How do you select a table?

481


What are the common mysql functions?

483


how to add a new column to an existing table?

561






What are the functions of commit and rollback statements?

554


What are mysql data types?

522


how you will Create a database on the mysql server with unix shell.

556


how to dump all databases for backup. Backup file is sql commands to recreate all db's.

450


How to escape special characters in sql statements?

525


What is a select query?

472


What does mysql_fetch_assoc do?

516


What are the differences between char and varchar data types?

496


Can we store files in mysql?

479


Which statement is used in a select query for partial matching?

610