sql unique
This constraint ensures all values in a column are unique. Example 1 (MySQL): Adds a unique constraint to the id column when creating a new users table. CREATE TABLE users ( id int NOT NULL, name varchar(255) NOT NULL, UNIQUE (id) ); Example 2 (MySQL): Alters an existing column to add a UNIQUE constraint. ALTER TABLE users ADD UNIQUE (id);