MySQL: UNIQUE constraint

[@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-ld6se]

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

[@jeevan7657]

Thank you so much for the lecture 😊🙏

[@kamal9294]

Thank you bro

[@zakiabdo6519]

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

[@dinushachathuranga7657]

thanks for nice video

[@akira-o4w]

thanks u so much

[@michaelanteneh2862]

I thank you in the name of “Bro”

[@haole1815]

Love u man! u make my day

[@mamisharoy3992]

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

[@chabdulwasay8840]

Will you also cover relational algebra?

[@yhx6218]

this is a good course

[@yhx6218]

yes

[@mohaymenul-islam]

✅ 9th October - 2024

[@mouadgamer8505]

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

[@mouadgamer8505]

varchar(25)*

[@catagna7273]

Varchar must be defined its length, imo.

[@harshh8923]

​@@mouadgamer8505yes

[@OpinionOfX]

Ravish kumar official

[@fyrukmcoo100]

:((

[@sk3yda005]

daphy sen de kimsin php sql allahi olmussun?