List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:April 16 2004 3:26pm
Subject:Re: Foreign Keys
View as plain text  
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

Thread
Foreign Keyslga216 Apr
  • Re: Foreign KeysMartijn Tonies16 Apr
RE: Foreign KeysVictor Pendleton16 Apr