Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Exclamation Unanswered: I Cant Delete A Parent Row. Help!!!

    On the child table , i have a FK(staffID) (allow null) that references the parent table via PK(staffID)(NOT NULL).
    I specified the rules below, yet I cant UPDATE or DELETE a row in the parent table.
    ON DELETE SET NULL,
    ON UPDATE CASCADE,

    LIFT ME UP PLEASE!!!!!!
    Last edited by mysql_Juli; 06-20-07 at 05:03.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    could you do a SHOW CREATE TABLE for both tables please
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    What is the error you are getting? Are you using InnoDB tables? As rudy suggests, please post your CREATE TABLE DDL.

Posting Permissions

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