Hello.
Your syntax shouldn't work in the MySQL server (comas at the end of CREATE TABLE
statments). What type of storage engine do you use? You can see it with the
following
statement:
SHOW CREATE TABLE MENU_GROUP;
[snip]
DROP DATABASE builder2;
GRANT ALL PRIVILEGES ON *.* TO [EM
> Sent: Thursday, January 27, 2005 10:17 AM
> To: mysql@lists.mysql.com
> Subject: cascade on delete problem
>
>
> Hello,
>
> I apologize for a possible simple question, but I am having
> trouble with the below code.
>
> I have three simple tables. In short, &qu
Hello,
I apologize for a possible simple question, but I am having trouble with the
below code.
I have three simple tables. In short, "menu_group" has an id, that is
referenced in the "menu_group_rel". When a user deletes an id from the
"menu_group", I wanted the entry in "menu_group_rel" (d