Przemysław Klein <[EMAIL PROTECTED]> wrote on 02/09/2006 04:24:14 AM:
> Hi All.
>
> How can I get to know which constraint fails when "Cannot delete or
> update a parent row: a foreign key constraint fails" error occurs?
>
> Thanks in advance
> prp
>
Hi All.
How can I get to know which constraint fails when "Cannot delete or
update a parent row: a foreign key constraint fails" error occurs?
Thanks in advance
prp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
foo foreign key(`d`) references `a` (`b`);
insert into c values(123);
=> ERROR 1216: Cannot add or update a child row: a foreign key constraint fails
>Fix:
Tell me which constraint fails, please.
>Submitter-Id:
>Originator:Matthias Urlichs
>Organization:
n
