> 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
> 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.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL