constraint in dbms/sql - (null / notnull, check, default , unique, primary key constraints)

𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗦𝗵𝗿𝗲𝗻𝗶𝗸 𝗝𝗮𝗶𝗻 - 𝗦𝘁𝘂𝗱𝘆 𝗦𝗶𝗺𝗽𝗹𝗶𝗳𝗶𝗲𝗱 (𝗔𝗽𝗽) :

𝗙𝗢𝗟𝗟𝗢𝗪 𝗠𝗘 𝗢𝗡:

𝗦𝗨𝗕𝗦𝗖𝗥𝗜𝗕𝗘 𝗧𝗢 𝗠𝗬 𝗬𝗢𝗨𝗧𝗨𝗕𝗘 𝗖𝗛𝗔𝗡𝗡𝗘𝗟𝗦:

[rahulkushwaha]

unique constraint can have multiple nulls... because null doesn't have any value and in unique to stop repeating we must have some number, data /values...null cant be compare to any other number so we can't say it is the same number or not.

[pickledkiwiana]

Good Job!! From New Zealand. I was so stuck on 'constraints' and this really helped me out :) Thank you

[shan]

n number of null values can be accepted because all the null value db will create an unique reference ID

[aravetithejaswani]

I want program and syntax for Null, Not null, check, default, unique

[priyankachauhan]

Data type of Mobile no is NUMBER not character, this is a mistake

[Awoit]

What's the difference between using the NULL constraint versus simply not using NULL/NOT NULL as a constraint?


Rather than saying customer_name char(10) NULL, why not use customer_name char(10) ...?

[criclovers..]

I think ur the q spider students
Bcq I'm doing same way explanation. concept of constraints

[prasadnastik]

Bro mobile number will have data type as number(10) not char(10)
Char is used only for characters n strings that's it
Correct that example
Or else your Vedio is excellent
Good explanation 🤗🤗🤗🤗

[chittaranjandas]

Sir how you shift to mathematics gate from DBMS

I was following you since 2 year today I found that you teach DBMS shocked 😲

[ShrenikJain]

get BEST NOTES for FREE !! fill this form -

[sanisan]

Everything is nice... beautifully explained..
But u didn't define what a constraint is

[MrBlack_Beard]

beta constrain toh explain kar direct examples

[srishtichaubey]

your voice is much better in hindi, work a little bit on ur english