List:General Discussion« Previous MessageNext Message »
From:Gitte und Ingolf Date:January 28 2004 10:56am
Subject:InnoDB on delete, on update
View as plain text  
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 not met,the Update fails and all changes are rolled back?
Or is the Update done?
 
What is the meaning of ON UPDATE CASCADE and ON UPDATE SET NULL??
 
Thanks for your help
 
 
 

Thread
InnoDB on delete, on updateGitte und Ingolf28 Jan
Re: InnoDB on delete, on updateVictoria Reznichenko28 Jan