> link varchar(250),
> FOREIGN KEY (data_id) REFERENCES MENU_GROUP(id) ON
> DELETE CASCADE
> ) TYPE=InnoDB;
>
> ERRORS
>
> -Original Message-
> From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 27, 2005 11:06 AM
> To: mysql@l
ary 27, 2005 11:59 AM
To: V. M. Brasseur; mysql@lists.mysql.com
Subject: RE: Cascade problem now error:
Thanks for the info on the command line util. I am new and was unaware of it.
But anyway, I have gone through the docs many more times, and I cannot figure
out where my problem is. Of course the error
link varchar(250),
FOREIGN KEY (data_id) REFERENCES MENU_GROUP(id) ON DELETE CASCADE
) TYPE=InnoDB;
ERRORS
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 11:06 AM
To: mysql@lists.mysql.com
Subject: Re: Cascade problem now error:
Have yo
Have you tried perror yet?
[EMAIL PROTECTED] (ping-300) 120 > perror 150
MySQL error: 150 = Foreign key constraint is incorrectly formed
Cheers,
--V
Scott Purcell wrote:
Thanks,
I updated my script and all looks good. But now I get an error when tryng to
issue this command.
Any ideas?
Thanks,
Sco
Thanks,
I updated my script and all looks good. But now I get an error when tryng to
issue this command.
Any ideas?
Thanks,
Scott
mysql> ALTER TABLE MENU_GROUP_REL ADD CONSTRAINT PK_MENU_GROUP_REL FOREIGN KEY(d
ata_id) REFERENCES MENU_GROUP(id) ON DELETE CASCADE;
ERROR 1005: Can't create table
