Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: Foreign Key Creation Problem

    I'm currently using MySQL Query Browser to create my database but I seem to be having trouble creating the foreign keys.

    The auto-generated code is created below but it throws up an error when executed:

    SQL Query

    ALTER TABLE projectdatabase.notifications ADD FOREIGN KEY Person_ID (Person_ID)
    REFERENCES persons (Person_ID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;


  2. #2
    Join Date
    Oct 2004
    Posts
    29
    Problem solved.
    Last edited by Wealth-Builderz; 12-04-04 at 15:47.

Posting Permissions

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