| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jay Paulson | Date: | February 20 2007 10: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 Paulson | 20 Feb |
| • Re: Alter table - adding constraints? | Chris White | 20 Feb |
| • Re: Alter table - adding constraints? | Jay Paulson | 20 Feb |
| • Re: Alter table - adding constraints? | Chris White | 21 Feb |
| • Re: Alter table - adding constraints? | Jay Pipes | 22 Feb |
