Howdy all,
Quick question about foreign keys. If I have a
database with foreign keys setup, then drop one of the
tables (which is referenced by many of the others) and
re-add the table, will the existing FKs work?
I'm seeing errors in SHOW INNODB STATUS under the
LATEST FOREIGN KEY ERRORS section that claim that the
referenced table (the one I dropped and readded)
doesn't exist. It does, I can query it and join to it,
but I can't do inserts into any table that references
the table.
Any ideas?
Cheers,
Tripp
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
