Kevin Powell - Community•2y ago

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()
);

4 Replies

StefanH•2y ago

Add UNIQUE to the column definition

LekeOP•2y ago

Thanks

Unknown User•2y ago

Message Not Public

LekeOP•2y ago

Thanks, the documentation is really helpful

Gaming

Programming

How to make SQL Table Column data UNIQUE