MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Foreign Key Error 121
Posted by: Heikki Tuuri
Date: April 11, 2006 02:49PM

Stephen,

TABLE: name SYS_FOREIGN, id 0 11, columns 8, indexes 3, appr.rows 2

there indeed are two foreign key constraints though no table that could carry them exists inside InnoDB!

I have to check if I can find some simple bug that could explain this strange situation.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Foreign Key Error 121
22698
Stephen Lynch
April 07, 2006 08:35AM
Re: Foreign Key Error 121
6494
Heikki Tuuri
April 09, 2006 01:38PM
Re: Foreign Key Error 121
7551
Stephen Lynch
April 10, 2006 05:52AM
Re: Foreign Key Error 121
4179
Jim Maher
April 17, 2009 09:54AM
Re: Foreign Key Error 121
4538
Heikki Tuuri
April 10, 2006 07:06AM
Re: Foreign Key Error 121
4407
Stephen Lynch
April 10, 2006 07:48AM
Re: Foreign Key Error 121
3863
Heikki Tuuri
April 10, 2006 06:06PM
Re: Foreign Key Error 121
5157
Stephen Lynch
April 11, 2006 09:08AM
Re: Foreign Key Error 121
3799
Heikki Tuuri
April 11, 2006 02:49PM
Re: Foreign Key Error 121
3976
Nathan Alden
September 17, 2007 05:54PM
Re: Foreign Key Error 121
6275
Noga Woronoff
September 26, 2007 09:55AM
Re: Foreign Key Error 121
3529
Dave Page
July 07, 2008 06:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.