| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Chris White | Date: | February 20 2007 11:08pm |
| 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 Paulson | 20 Feb |
| • Re: Alter table - adding constraints? | Chris White | 20 Feb |
| • Re: Alter table - adding constraints? | Jay Paulson | 20 Feb |
| • Re: Alter table - adding constraints? | Chris White | 21 Feb |
| • Re: Alter table - adding constraints? | Jay Pipes | 22 Feb |