Re: Foreign key contraints, on delete cascade not working?

Victoria Reznichenko wrote: Andrew DeFaria <[EMAIL PROTECTED]> wrote: Victoria Reznichenko wrote: Andrew DeFaria <[EMAIL PROTECTED]> wrote: As you can see I when I delete from user (the parent table) the useropts (child table) entry remains. Shouldn't it be deleted? Heikki

Re: Foreign key contraints, on delete cascade not working?

Victoria Reznichenko wrote: Andrew DeFaria <[EMAIL PROTECTED]> wrote: I created the following .sql file to demonstrate a problem I'm having. According to the manual: If |ON DELETE CASCADE| is specified, and a row in the parent table is deleted, then InnoDB automatically d

Foreign key contraints, on delete cascade not working?

I created the following .sql file to demonstrate a problem I'm having. According to the manual: If ON DELETE CASCADE is specified, and a row in the parent table is deleted, then InnoDB automatically deletes also all those rows in the child table whose foreign key values are equal to the refere