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?


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


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 .net-4.0

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