What?s the difference between PRIMARY KEY and UNIQUE in
Answers were Sorted based on User's Feedback
Answer / amith
PRIMARY KEY cannot be null, so essentially PRIMARY KEY is
equivalent to UNIQUE NOT NULL
|Is This Answer Correct ?||28 Yes||8 No|
Answer / niraj kumar
primary key is not accept the null value.primary key is
always autoincrement.unique key is accept the one null
value.it is not a autoincrement.
|Is This Answer Correct ?||4 Yes||15 No|
Answer / manish
Primary Keys are used in building relationships between
tables in a database. (an index is automatically created on
the primary key). The difference between primary and
ordinary keys is that there can be multiple keys, but only
one primary key.
|Is This Answer Correct ?||7 Yes||20 No|
What is foreign key in mysql?
What is the difference between b-tree and hash indexes?
Do while loop in mysql procedure?
Can I use mysql for free?
What is a select query?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How do you backup a database in mysql?
What is the default port for mysql and how it can change?
Is SET Command is SQL Statement..?
What, if a table has one column defined as TIMESTAMP?
Why we use mongodb instead of mysql?
How does mysql clustering work?