From: Martijn Tonies
Date: April 16 2004 3:26pm
Subject: Re: Foreign Keys
List-Archive: http://lists.mysql.com/mysql/163796
Message-Id: <003d01c423c7$3cc82430$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> I am new to mysql. I am trying to create tables with foreign key
constraints.
> but the constraintsdoesnt seem to be showing any effect on the table. I am
> able to add any info in the foreign key table witout the same info in the
main
> table.
>
> what is the problem??

1) are you running the InnoDB version of MySQL?

2) are you using InnoDB tables?

If (1) and (2) are not satisfied, MySQL will parse your SQL
and totally ignore everything that has to with Foreign Keys.

With regards,

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