List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:April 16 2004 3:26pm
Subject:Re: Foreign Keys
View as plain text  

> I am new to mysql. I am trying to create tables with foreign key
> 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
> 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
Upscene Productions

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