Re: cascade on delete problem

2005-01-28 Thread Gleb Paharenko
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

RE: cascade on delete problem

2005-01-27 Thread Artem Koltsov
> 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

cascade on delete problem

2005-01-27 Thread Scott Purcell
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