Q:

Cannot create table - Cannot add foreign key constraint

I have a strange case:
It works:
    Create table `testasd`(  
  `asd` int(10) NOT NULL,
  primary key (`asd`)
)

but this does not work:
    Create table `test1`(  
  `asd` int(10) NOT NULL,
  primary key (`asd`)
)

Cannot add foreign key constraint

A:

error returned by the mysql is misleading
To find the specific error run this:

SHOW ENGINE INNODB STATUS;

