What is the difference between a primary key and a unique constraint?

sql primary-key
Tim picture Tim · Aug 20, 2009 · Viewed 41.8k times · Source

Someone asked me this question on an interview...

Answer

Håvard picture Håvard · Aug 20, 2009

Primary keys can't be null. Unique keys can.

Related questions

How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I …

Read More
Add primary key to existing table

I have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I created this table, I set PersionId and Pname as the primary key. I now want to include one more column …

Read More
difference between primary key and unique key

I'm using mysql database. I have a confusion between primary key and unique key. Please help me where should I create primary and unique key. I mean in which situation we create unique key or primary key .

Read More