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]
