How to make SQL Table Column data UNIQUE - Kevin Powell - Community

Kevin Powell - Community•4y ago•

4 replies

How to make SQL Table Column data UNIQUE

I created this Clubs table in my SQL database but I want to make name row unique such that two rows will not have the same name.

CREATE TABLE clubs (
  `id` integer PRIMARY KEY AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `league` VARCHAR(45) NOT NULL,
  `isActive` BOOLEAN,
  created TIMESTAMP NOT NULL DEFAULT NOW()
);

CREATE TABLE clubs (
  `id` integer PRIMARY KEY AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `league` VARCHAR(45) NOT NULL,
  `isActive` BOOLEAN,
  created TIMESTAMP NOT NULL DEFAULT NOW()
);