Topics

Kevin Powell - Community•17mo 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•17mo ago

Add UNIQUE to the column definition

Leke•17mo ago

Thanks

Unknown User•17mo ago

Message Not Public

Sign In & Join Server To View

Leke•17mo ago

Thanks, the documentation is really helpful

Kevin Powell - Community Join

A friendly place for developers to meet other devs, ask questions, get help, and just have a good time 🙂.

34KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

How do I call callback on blur but only when the focus item is not a childSo i have this structure: ``` <div onBlur={...}> <input type="text"/> <div id={"content"}lookin for feedbacks from mobile view at portfolio sectioni've created a portfolio for myself, but i fixed it in some media queries, for laptop , iphone x, ip how to make favicon bigger ?i've been trying to find a way but still looks so small ? is that im using wrong or what ?MaskingI am trying to mask an svg with a solid color. I know I can only mask with a gradient or an image. I Common folder names for organization in ReactHello, I started learning about react and after many videos I notice that there were a lot of folder somebody tell me why this happens ?Need ideas for a nested ul layoutI need ideas, suggestions or examples for a nice way to display a nested ``ul`` (or perhaps, a bette Inquiry about using Figma templates for personal projectsHi, I'm currently working on building some personal projects and as I am not a designer, I would lik can somebody tell me why im getting this error ?Why does accessing the session object make Express-Session work?My sessions suddenly stopped being saved, and cookies stopped being set. All routes were working, an