WHAT IS 'ON DELETE CASCADE' AND 'ON DELETE SET NULL' IN SQL?

[@harshilsoni859]

Thank you so much! I finally got what I was looking for..

[@현정-c9p]

Thank you so much! I needed this sooo much From🇰🇷

[@charlesabju907]

Spectacular explanation, thank you very much.

[@crackconcepts]

Glad it was helpful!

[@staskvcz]

Thank you for such good explanation

[@Mahesh717]

i have a doubt? in which we are setting null if it contains a primary key or act as an primary key, then we cannot set it as null, bcoz its a primary key..so in this case the best option will be On delete cascade Right...

[@sameerraj8506]

well explained!! THANKS

[@aakarshpratap3200]

have my interview today (Feb 28 - 2022) at 1 pm at a tech giant. Hope i do well with your video's help

[@bingocomedy7684]

thank you so much for the explaination

[@emmanuelU17]

Short and very detailed

[@varshinikaithapuram6189]

Should the on delete cascade constraint be used while creating the table itself??

[@MaltheHave]

I think so. Else you need to drop and re add the CONSTRAINT. See this SO answer: stackoverflow.com/a/14182346/8660908

[@ravids5497]

Hello could you guide me how to set cascade delete for existing table

[@einsteinash2207]

I have some queries related MySQL , can u help?

[@SOUF1YAN]

Thank you so much!

[@Gorky25]

We immediately can know who is a parent and who is a child when we see who has FK on his table, right? FK always has a child, and the parent never can have FK of the child? p.s. What is mean - Cascade?

[@jerishnixon7033]

Thankyou so much😊

[@pragyasharma4936]

nice explanation

[@handle-handler]

Thanks you for helping

[@chiranjibsahoo2152]

thanks for ur helping

[@yogeshthorat2477]

Thanks Maa'm

[@WeirdStuffaaaa]

thanks .

[@sanjayyv6888]

Thanks

[@j.vamshikrishna5714]

👍✌️

[@omarzahran4179]

Thank you so much! I finally got what I was looking for..

[@jasoncysiu]

Thanks