Re: problem przy tworzeniu klucza obcego w MySQL

Article View: pl.comp.bazy-danych

Article #183324

Back to pl.comp.bazy-danych Previous Next

#183324

From: Krzysztof Krzyżaniak
Date: Wed, 08 Jul 2009 18:21

16 lines
1413 bytes

jivanmukta@poczta.onet.pl writes:

>> $ perror 150
>> MySQL error code 150: Foreign key constraint is incorrectly formed
>
> ale mój klucz obcy jest poprawnie zbudowany:
>   CONSTRAINT `allegro_template_product_id_fkey` FOREIGN KEY (`product_id`) 
> REFERENCES `product` (`id`) ON UPDATE NO ACTION

Może masz duplikaty w tabeli?

  eloy
-- 
-------e-l-o-y----------------------------e-l-o-y-@-k-o-f-e-i-n-a-.-n-e-t------

       jak to dobrze, że są oceany - bez nich byłoby jeszcze smutniej

Technical Details

Message-ID: <gnus.878wiz593m.fsf.eloy@kofeina.net>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail

References: <h31lf7$qel$1@atlantis.news.neostrada.pl> <796e.00000af9.4a5472b9@newsgate.onet.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!not-for-mail
From: Krzysztof Krzyżaniak <eloy@kofeina.net>
Newsgroups: pl.comp.bazy-danych
Subject: Re: problem przy tworzeniu klucza obcego w MySQL
Date: Wed, 08 Jul 2009 20:21:33 +0200
Organization: http://www.wikia.com/ -- We are good guys!
Lines: 16
Message-ID: <gnus.878wiz593m.fsf.eloy@kofeina.net>
References: <h31lf7$qel$1@atlantis.news.neostrada.pl> <796e.00000af9.4a5472b9@newsgate.onet.pl>
NNTP-Posting-Host: chlor.kofeina.net
Mime-Version: 1.0
X-Trace: inews.gazeta.pl 1247077827 4980 194.114.145.51 (8 Jul 2009 18:30:27 GMT)
X-Complaints-To: usenet@agora.pl
NNTP-Posting-Date: Wed, 8 Jul 2009 18:30:27 +0000 (UTC)
Cancel-Lock: sha1:5uRwVo50d3cRbtWXctcELfC+ubc=
X-User: eloy
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.3 (gnu/linux)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message