MySQL: CHECK constraint is easy

Показать описание

#MySQL #SQL #tutorial

The CHECK constraint is used to limit what values can be placed in a column.

00:00:00 intro
00:00:43 CHECK constraint for a new table
00:01:45 CHECK constraint for an existing table
00:02:30 demonstration
00:03:19 drop a CHECK constraint
00:03:40 conclusion

Рекомендации по теме

Комментарии

– 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;

BroCodez

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

MinhVu-bzfe

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

TheLastRaven

You are good man you make it easy for us

mdjahangirhossain

That fast forwarded typing sound so satisfying

Vivek_xkt

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)

mhreda

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

avaygc

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.

enlightened

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?

sifatniloy

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

MalayalamTele

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

fsrinivas

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

ابوعمر-ذسج

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

haole

MySQL: CHECK constraint is easy

MySQL: CHECK constraint is easy

SQL CHECK Constraint | SQL Server Tutorial for Beginners

Drop Check Constraint on SQL Server

SQL CHECK Constraints: A Step-by-Step Tutorial

MySQL Check Constraint

CHECK Constraint | Oracle SQL Tutorial for beginners | Techie Creators

Add check constraint to existing column of a table in Mysql

17. how to use CHECK constraint in SQL

37 SQL Server - SQL CHECK Constraint

SQL CHECK Constraint

check constraint in mysql || mysql check constraint || check constraint || constraint in dbms#short

MySQL: DEFAULT constraint is easy

Check Constraint In MySQL in Hindi - 46

Databases: MySQL Constraints - Check Constraint

10 SQL Check Constraint in MySQL

How to remove or drop CHECK constraint in Mysql tutorial

How to add CHECK CONSTRAINT on specific column(field) of an existing table in MySQL

SQL check constraint : email validation in 50 seconds #coding #tutorial

MySQL : CHECK constraint in MySQL is not working

T-SQL - CHECK Constraints

MySQL Tutorials | mysql Check Constraint | check in mysql | mysql constraints violation

how to create check constraint in sql table.

MySQL CHECK Constraint| How to Add Check Constraint?| How to Add on Multiple Column #mysql #inhindi

SQL-Lecture-4 (Check Constraint - Part-2)