How to set two foreign keys from one table?

Vote count:

0

I have two tables USERS and FRIENDSHIPS,what i need is to record friendships between users in FRIENDSHIPS table.I think i should use two foreign keys from USERS table one for the primary user and the other for user he is friends with.I just started learning so i only know to use Workbench to some extent.My question is how do you set up two foreign keys from the same table?

asked 31 secs ago

Jasko

27

How to set two foreign keys from one table?