MySQL: UNIQUE constraint

#MySQL #tutorial #course

00:00:00 add UNIQUE CONSTAINT to a new table
00:01:12 add UNIQUE CONSTAINT to an existing table
00:02:00 demonstration

CREATE TABLE products (
product_id INT,
product_name varchar(25) UNIQUE,
price DECIMAL(4, 2)
);

ALTER TABLE products
ADD CONSTRAINT
UNIQUE (product_name);

INSERT INTO products
VALUES (100, 'hamburger', 3.99),
(101, 'fries', 1.89),
(102, 'soda', 1.00),
(103, "ice cream", 1.49);

SELECT * FROM products;

[BroCodez]

CREATE TABLE products (
product_id INT,
product_name varchar(25) UNIQUE,
price DECIMAL(4, 2)
);

ALTER TABLE products
ADD CONSTRAINT
UNIQUE (product_name);

INSERT INTO products
VALUES (100, 'hamburger', 3.99),
(101, 'fries', 1.89),
(102, 'soda', 1.00),
(103, "ice cream", 1.49);

SELECT * FROM products;

[Leo-ldse]

holy, 3 vids in a day? Give my man a medal

[mamisharoy]

Just a question. Does adding a Unique constraint to a column or making the same column a primary key produce the same effect?

[chabdulwasay]

Will you also cover relational algebra?

[zakiabdo]

Bro you're saving my life ty 😭😭😭😭

[mouadgamer]

my question is :
this code correct ?
alter table products
modify product_name varchar unique;

[skyda]

daphy sen de kimsin php sql allahi olmussun?