MySQL - Foreign keys

SilverHood

FH is my second home
Joined
Dec 23, 2003
Messages
2,160
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 :)
 

Users who are viewing this thread

Top Bottom