Question

How can we assign FOREIGN KEY constraint on multiple columns?

Answer 1

MySQL allows us to add a FOREIGN KEY constraint on multiple columns in a table .The condition is that each Foreign Key in the child table must refer to the different parent table.