Re: Alter table - adding constraints?

[Chris White]

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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]