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
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,
) 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 you tried perror yet?
[EMAIL PROTECTED] (ping-300
; 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 is a foreign key problem, but I do
;
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 you tried perror yet?
[EMAIL PROTECTED] (ping-300) 120 perror 150
MySQL error: 150 = Foreign