Professional Web Applications Themes

error 150 - MySQL

i have created 2 tables and want to make a FK between them, ALTER TABLE `icts`.`fact_customer_feedback` ADD CONSTRAINT `FK_fact_customer_feedback_2` FOREIGN KEY `FK_fact_customer_feedback_2` (`CFcustomer_Id`) REFERENCES `fact_customer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT; but it ruturns the error number 1452 cannot add or update a child row : a foreign key constraint fails. thanks...

  1. #1

    Default error 150

    i have created 2 tables and want to make a FK between them,
    ALTER TABLE `icts`.`fact_customer_feedback` ADD CONSTRAINT
    `FK_fact_customer_feedback_2` FOREIGN KEY `FK_fact_customer_feedback_2`
    (`CFcustomer_Id`)
    REFERENCES `fact_customer` (`id`)
    ON DELETE RESTRICT
    ON UPDATE RESTRICT;
    but it ruturns the error number 1452
    cannot add or update a child row : a foreign key constraint fails.

    thanks


    Teng Tao Guest

  2. #2

    Default Re: error 150

    Teng Tao wrote:
    > i have created 2 tables and want to make a FK between them,
    > ALTER TABLE `icts`.`fact_customer_feedback` ADD CONSTRAINT
    > `FK_fact_customer_feedback_2` FOREIGN KEY `FK_fact_customer_feedback_2`
    > (`CFcustomer_Id`)
    > REFERENCES `fact_customer` (`id`)
    > ON DELETE RESTRICT
    > ON UPDATE RESTRICT;
    > but it ruturns the error number 1452
    > cannot add or update a child row : a foreign key constraint fails.
    >
    > thanks
    >
    >
    You have (at least) a row in fact_customer_feedback.CFcustomer_Id which
    does not exist in fact_customer.id.

    When you create any constraint (not just a foreign key), all rows in the
    table must satisfy the constraint or the creation will fail.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: error 150

    Teng Tao wrote:
    > i have created 2 tables and want to make a FK between them,
    > ALTER TABLE `icts`.`fact_customer_feedback` ADD CONSTRAINT
    > `FK_fact_customer_feedback_2` FOREIGN KEY `FK_fact_customer_feedback_2`
    > (`CFcustomer_Id`)
    > REFERENCES `fact_customer` (`id`)
    > ON DELETE RESTRICT
    > ON UPDATE RESTRICT;
    > but it ruturns the error number 1452
    > cannot add or update a child row : a foreign key constraint fails.
    In addition to Jerry's advice, it is also common that one gets this
    error because the referencing and referenced columns aren't of
    compatible datatypes.

    Read the conditions for creating a foreign key on this doc page:
    [url]http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html[/url]

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. Replies: 0
    Last Post: March 29th, 09:49 PM
  2. Replies: 0
    Last Post: November 10th, 05:24 PM
  3. Postscript Print error (ERROR: rangecheck; OFFENDING COMMAND: filter)
    By Darrell_J_Brown@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: May 13th, 11:24 AM
  4. Replies: 0
    Last Post: September 25th, 03:23 AM
  5. Replies: 1
    Last Post: August 7th, 07:13 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139