List:General Discussion« Previous MessageNext Message »
From:Chris White Date:February 21 2007 12:08am
Subject:Re: Alter table - adding constraints?
View as plain text  
Jay Paulson wrote:
> 2) both tables have data in them.
>
>   
This is most likely your issue then, depending on the table size, go 
through and make sure that anything in the referenced column matches the 
referencing column.  You should also be able to use SHOW INNODB STATUS 
to see what's possibly failing.
Thread
• Alter table - adding constraints?Jay Paulson20 Feb
  • Re: Alter table - adding constraints?Chris White20 Feb
    • Re: Alter table - adding constraints?Jay Paulson20 Feb
      • Re: Alter table - adding constraints?Chris White21 Feb
        • Re: Alter table - adding constraints?Jay Pipes22 Feb