SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot Nova's Avatar
    Join Date
    Sep 2002
    Location
    Netherlands
    Posts
    127
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    trigger in combination of Foreign Key

    I have create a trigger with the BEFORE DELETE event
    and also have a CASCADE relation on the table.

    so when the record is deleted the trigger is not being executed.
    is this becouse of mysql doen's support it or.. am i doing something wrong
    if you can't beat them call them cheaters

    www.phppatterns.nl

  2. #2
    SitePoint Guru
    Join Date
    Jan 2004
    Location
    Uppsala, sverige
    Posts
    695
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    From the Mysql manual, chapter on create trigger

    Note: Currently, triggers are not activated by cascaded foreign key actions. This limitation will be lifted as soon as possible.

  3. #3
    SitePoint Zealot Nova's Avatar
    Join Date
    Sep 2002
    Location
    Netherlands
    Posts
    127
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ty i read over that one.
    if you can't beat them call them cheaters

    www.phppatterns.nl


Bookmarks

Posting Permissions

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