Re: mysql error code:150
Posted by:
Alex Zinc
Date: August 29, 2008 07:56AM
I faced this problem as well and when i specified the option engine=myisam, everything went well, but the foreign keys didn't work at all as myisam doesn't support them. One of the advices I saw here was to check whether the tables connected with foreign keys were running on the same engine, but I created them, including the one with foreign keys, without specifying the ingine, so they all must run on innodb, but nevertheless the error occurs. Why?
Edited 2 time(s). Last edit at 08/30/2008 05:16AM by Alex Zinc.
Subject
Views
Written By
Posted
20609
December 13, 2007 01:18AM
9082
December 21, 2007 11:34PM
6112
May 15, 2008 07:40AM
Re: mysql error code:150
6153
August 29, 2008 07:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.