MySQL Database

MySQL Unique

Prevent duplicate values in a column or column combination.

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

A UNIQUE constraint rejects duplicate non-null values.