List:General Discussion« Previous MessageNext Message »
From:Jay Paulson Date:February 20 2007 9:46pm
Subject:Alter table - adding constraints?
View as plain text  
I really don¹t know what to do because I keep getting this error.  Any
ideas?

SQL query:

ALTER TABLE pl_reports ADD CONSTRAINT fk_region FOREIGN KEY ( region )
REFERENCES Region( id ) ON UPDATE CASCADE ON DELETE CASCADE

MySQL said: Documentation
#1005 - Can't create table './survey_localhost/#sql-113_f8.frm' (errno: 150)

Thanks!

Thread
Alter table - adding constraints?Jay Paulson20 Feb
  • Re: Alter table - adding constraints?Chris White20 Feb
    • Re: Alter table - adding constraints?Jay Paulson20 Feb
      • Re: Alter table - adding constraints?Chris White21 Feb
        • Re: Alter table - adding constraints?Jay Pipes22 Feb