Re: Alter table - adding constraints?

[Jay Pipes]

Chris White wrote:
> 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.

No, it's because you already have a constraint in your schema called 
fk_regions.  Just change the constraint name to one that is unique for 
your schema...  This is the reason I usually name myu constraints like:

fk_fromtable_totable

So this doesn't become an issue.

cheers,

Jay