i have an mysql question which is causing me trouble, i am using both phpmyadmin and mysql gui for my work..
my problem is when i try to enforce the on cascade delete functionality i run into this error:
ALTER TABLE properties_details ADD FOREIGN KEY ( suburb_id ) REFERENCES suburbs( suburb_id ) ON DELETE CASCADE ;
the suburb_id in the properties_details table is the foriegn key and inj the suburb table it is the primary key..
so when i run it, it gives me this error:
MySQL said:
#1005 - Can't create table '.\realestatenz\#sql-1698_14.frm' (errno: 150)
has anybody have experience in it
please let me know thanks
suburb have suburb_id as primary key
properties_details table have the suburb_id field
when i run it gets me to above error: