From: Date: January 28 2004 10:56am
Subject: InnoDB on delete, on update
List-Archive: http://lists.mysql.com/mysql/158521
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0000_01C3E58D.546A54F0"

------=_NextPart_000_0000_01C3E58D.546A54F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi out there,
=20
i=B4m using InnoDB with foreign key constraints and i=B4m looking for =
the
default behavior of ON DELETE and ON UPDATE.
=20
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?
=20
What is the meaning of ON UPDATE CASCADE and ON UPDATE SET NULL??
=20
Thanks for your help
=20
=20
=20

------=_NextPart_000_0000_01C3E58D.546A54F0--