I think I may have discovered one of my issues, is memberID in Table2 was primary key. Should not have been. As far as the error messages in removing key, I'm still unsure.
Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Two tables: > > Table1 [innodb] > userID..... > addtlfields..... > > Table2 [innodb] > memberID..... > addtlfields..... > > I created a foreign key in Table2 for memberID to > userID > set to "no action" on both delete and update. > > I get this error when I try to add a record to table > 2:"Cannot add or update a child row: a foreign key > constraint fails" > > I try and remove the foreign key and it won't let > me: > > 1025-Error on rename of './mydatabase/table to > './mydatabase/#sql2-695b-c4ac0'(errno: 152) > > I think can probably forgoe the foreign key , but > what's with all the error messages ? > > Thank you, > Stuart > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
