Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2014
    Posts
    2

    Unanswered: how to use cascade on delete in mysql

    i use this code of cascade on delete but it don't reflect any change please help..
    and tell me my mistake .
    and i also want to know about cascade on update and how to use it because m facing similar problem in that

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    assuming you are using INNODB tables then you can define delete cvascade (and for that matter update cascade)...
    MySQL :: MySQL 5.6 Reference Manual :: 14.2.6.6 InnoDB and FOREIGN KEY Constraints

    so when you delete (or update) the 'parent' item it automatically cascades the delete (or update) to 'child' items
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Should not be updating the primary key

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •