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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
