MySQL: CHECK constraint is easy

[@BroCodez]

- The CHECK constraint is used to limit what values can be placed in a column. CREATE TABLE employees( employee_id INT, first_name VARCHAR(50), last_name VARCHAR(50), hourly_pay DECIMAL (5, 2), hire_date DATE, CONSTRAINT chk_hourly_pay CHECK (hourly_pay >= 10.00) ); ALTER TABLE employees ADD CONSTRAINT chk_hourly_pay CHECK (hourly_pay >= 10.00); INSERT INTO employees VALUES (6, "Sheldon", "Plankton", 5.00, "2023-01-07"); ALTER TABLE employees DROP CHECK chk_hourly_pay;

[@MinhVu-bz6fe]

You're literally carrying me through Uni right now. Thank you, Bro. Truly.

[@toke7342]

Literally?

[@Vivek_xkt]

That fast forwarded typing sound so satisfying

[@TheLastRaven]

We literally started sql today your timing is great thank you.

[@KarolKasperek]

same

[@nihongo_]

best channel ever!

[@mdjahangirhossain6203]

You are good man you make it easy for us

[@ahmetunaldi7601]

Bro is great....

[@avaygc5646]

your tutorial is great could please make a tutorial for node js and dyango 💗

[@enlightened7354]

Can you make also mongo db and Java Spring tutorials? Thanks man. Because of you i learned MySQL. I was struggling and now im able to write my own database in Java using JDBC.

[@MalayalamTele]

ALTER ADD not working with constrain. Error code 3819 Check Constraint 'chk_hourly_pay' is violated

[@sifatniloy3783]

I got Error Code: 3821. Check constraint 'check_hourly_pay' is not found in the table, may be I mistyped the constraint. How to find out what I gave the constraint name for that column?

[@mateenraza7340]

In the output window, it lists the action you make; you can find out what name have you mistyped from there.

[@mhreda1849]

Thank you ! Notice : when i want to delete constraint check drop check "constraintName" => is not working for me but when i do : drop constraint "constraintName" maybe the first syntax is not correct and thank you again :) (FROM MOROCCO)

[@KoenigOne]

thanks bro

[@f15srinivas82]

there should be another name for this channel that is 'bro god" really you are god for us bro.

[@richardsijebor2059]

This is extreme man. "god" ?. You should speak for yourself.

[@mechagear4819]

@@richardsijebor2059 shut your dumbass up lil boy

[@haole1815]

First comment !!! U make my day Bro :D

[@BroCodez]

🎉

[@ابوعمر-ذ3س3ج]

Drop check doesn't work in Microsoft sql can anyone help

[@dae-dalus]

DROP CONSTRAINT should work

[@mohaymenul-islam]

✅ 10th October - 2024

[@OliviaChen0806]

Morning, Where is the game bro 🥹

[@Kanal-l6o]

Y

[@Kanal-l6o]

S

[@Kanal-l6o]

E

[@fyrukmcoo100]

:((