Is there any way to add multiple foreign keys for SQL columns but they should refer to a row in other table?
I am trying to find a query like this. Is it possible in MySQL? ALTER TABLE `table1` ADD CONSTRAINT my_constraint_name FOREIGN KEY (some_id, some_other_id) REFERENCES `table2`(id, other_id); My scenario is, table1.some_id should be referred to table2...