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?

Answers


MyISAM does not support foreign key constraint.

Both table needs to be InnoDB.

Change engine to InnoDB first.


Need Your Help

ASP.NET MVC: Have total control over the URL

c# asp.net-mvc

I am developing a website that has nested categories. I would like the categories to be in the url such as something like this

Could not load type 'System.Web.Mvc.ViewUserControl<SOMETYPE>'

.net asp.net-mvc .net-4.0

I'm trying to deploy ASP.NET MVC 2 project (VS2010) to Win Server 2008 R2