Re: mysql error code:150
Gavy,
Verify the data types that you have assigned the suburb_id field in both the suburb and the properties_details tables.
Most likely you have mismatched data types. For example:
CREATE TABLE suburb (
suburb_id int(10) signed PRIMARY KEY auto_increment
)
CREATE TABLE properties_details (
suburb_id mediumint(11) unsigned,
FOREIGN_KEY (suburb_id) REFERENCES suburb(suburb_id)
)
Any of the three mismatched I demostrated (length, specific type, or signed vs. unsigned) could cause your problem.
Subject
Views
Written By
Posted
20597
December 13, 2007 01:18AM
Re: mysql error code:150
9078
December 21, 2007 11:34PM
6110
May 15, 2008 07:40AM
6150
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.