Re: InnoDB on delete, on update

2004-01-28 Thread Victoria Reznichenko
"Gitte und Ingolf" <[EMAIL PROTECTED]> wrote: > Hi out there, > > i.m using InnoDB with foreign key constraints and i.m looking for the > default behavior of ON DELETE and ON UPDATE. > > Secondly, what does the ON UPDATE NO ACTION option means? Ist the way it is > used in db2, that every child row

InnoDB on delete, on update

2004-01-28 Thread Gitte und Ingolf
Hi out there, i´m using InnoDB with foreign key constraints and i´m looking for the default behavior of ON DELETE and ON UPDATE. Secondly, what does the ON UPDATE NO ACTION option means? Ist the way it is used in db2, that every child row must have some matching parent row. If this condition is