Two tables which have different engines can't have foreign keys?
I have table A (innoDB) and table B (MyISAM). When I add foreign keys from A to B. It reports:
ERROR 1005: Can't create table (errno: 150)
Why is it?
Both table needs to be InnoDB.
Change engine to InnoDB first.