A PRIMARY KEY is a column (or combination of columns) that uniquely identifies each record in a table. No two rows can have the same primary key value, and it cannot be empty (NULL).
Rules for primary key:
- Must contain unique values
- Cannot be NULL
- Each table should have only one primary key
CREATE TABLE students (
student_id INT PRIMARY KEY,
name VARCHAR(50),
age INT
);