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
Hello Scott, Make sure your tables are InnoDB type: CREATE TABLE table_name ( table_def ...) ENGINE=InnoDB; If you have default MyISAM tables, it won't work because they don't support foreign keys. > -Original Message- > From: Scott Purcell [mailto:[EMAIL PROTECTED] > Sent: Thursday, J