Check the output of SHOW INNODB STATUS. You should see a more helpful
error message there.
This shows the following information:
LATEST FOREIGN KEY ERROR
070519 15:15:28 Error in foreign key constraint of table
woodturners/#sql-2dc_1e:
FOREIGN
Hi Jesse,
Jesse wrote:
Currently using MySQL version 5.0.22-community-nt on a Windows XP Pro
box (my development machine).
When I attempt to add a Foreign Key to one of my tables, I get the
error, "Can't create table '.\woodturners\#sql-2dc_8.frm' (errno: 150).
I have checked through all o
