Najoua Najoua - 1 month ago 12
MySQL Question

2 foreign keys referencing same table

Can I have two foreign keys in the same table that are referencing an other table named profil(same one) ?

my table is MailSent, it contains : primary key (Id), date, foreignkey1 (profil_sender), foreignkey2 (profil_receiver)

Answer

Add foreign keys (profil_sender_id, profil_receiver_id) to an existing table (MailSent), follow the following steps:

ALTER TABLE MailSent ADD CONSTRAINT fk_profile_sender_id FOREIGN KEY (profil_sender_id) REFERENCES TABLE-NAME(id);

ALTER TABLE MailSent ADD CONSTRAINT fk_profil_receiver_id FOREIGN KEY (profil_receiver_id) REFERENCES TABLE-NAME(id);