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

Поделиться
HTML-код
  • Опубликовано: 19 окт 2024

Комментарии • 26

  • @charlesabju907
    @charlesabju907 Год назад

    Spectacular explanation, thank you very much.

  • @harshilsoni859
    @harshilsoni859 3 года назад +2

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

  • @현정-c9p
    @현정-c9p 8 месяцев назад

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

  • @Mahesh717
    @Mahesh717 Год назад +1

    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...

  • @staskvcz
    @staskvcz 3 года назад +1

    Thank you for such good explanation

  • @sameerraj8506
    @sameerraj8506 10 месяцев назад

    well explained!! THANKS

  • @bingocomedy7684
    @bingocomedy7684 2 года назад

    thank you so much for the explaination

  • @aakarshpratap3200
    @aakarshpratap3200 2 года назад

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

  • @emmanuelU17
    @emmanuelU17 Год назад

    Short and very detailed

  • @SOUF1YAN
    @SOUF1YAN 2 года назад

    Thank you so much!

  • @jerishnixon7033
    @jerishnixon7033 2 года назад

    Thankyou so much😊

  • @varshinikaithapuram6189
    @varshinikaithapuram6189 3 года назад

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

    • @MaltheHave
      @MaltheHave 3 года назад

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

  • @handle-handler
    @handle-handler 4 года назад

    Thanks you for helping

  • @pragyasharma4936
    @pragyasharma4936 2 года назад

    nice explanation

  • @yogeshthorat2477
    @yogeshthorat2477 3 года назад

    Thanks Maa'm

  • @chiranjibsahoo2152
    @chiranjibsahoo2152 3 года назад

    thanks for ur helping

  • @einsteinash2207
    @einsteinash2207 3 года назад

    I have some queries related MySQL , can u help?

  • @WeirdStuffaaaa
    @WeirdStuffaaaa 3 года назад

    thanks .

  • @j.vamshikrishna5714
    @j.vamshikrishna5714 Год назад

    👍✌️

  • @ravids5497
    @ravids5497 4 года назад

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

  • @jasoncysiu
    @jasoncysiu 4 года назад

    Thanks

  • @Gorky25
    @Gorky25 4 года назад

    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?

  • @omarzahran4179
    @omarzahran4179 3 года назад

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

  • @sanjayyv6888
    @sanjayyv6888 5 лет назад

    Thanks