MySQL - Foreign keys

[SilverHood]

Are foreign keys declared in the same way as in oracle?

IE (using oracle sql as an example)

OrderID references BarOrder(OrderID)
or
Foreign key (BarID, JobID) references Bar)

The tool we've been given to use doesn't seem to do the relationships properly, so will have to do it manually.

Any help appreciated

 

[Jonty]

Hi SilverHood

Just a quickie Try the 3.6.6 Using Foreign Keys and 1.5.5.5 Foreign Keys in the MySQL Reference Manual.

Kind Regards

 

[SilverHood]

Ah cheers, they aren't needed then