From: Martijn Tonies
Date: November 3 2004 9:46am
Subject: Re: Foreign Key
List-Archive: http://lists.mysql.com/mysql/175170
Message-Id: <017701c4c189$f8af87f0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="KOI8-R"
Content-Transfer-Encoding: 8bit



> Hi all,  I whould like to know if there is a
> way to create Foreign Key´s between Parent and Child table, I realy dont
> know if is it possible to do it and if OK, how will be a simple SQL code
> of it.

Only for InnoDB tables - see:
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com