What is the difference between primary key and unique key?

Point	Primary key	Unique key
NULL allowed	No	Yes (it allows NULL values)
How many per table	One	Many
Purpose	Identifies each row	Stops duplicate values in a column, like email

CREATE TABLE users (
  id INT PRIMARY KEY,
  email VARCHAR(100) UNIQUE
);

See MySQL Constraints.

• Previous Interview Question
• Next Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.