这样的事情应该做到:
CREATE TABLE MyReferencingTable AS (
[COLUMN DEFinitioNS]
refcol1 INT NOT NULL,
rofcol2 INT NOT NULL,
CONSTRAINT fk_mrt_ot FOREIGN KEY (refcol1, refcol2)
REFERENCES OtherTable(col1, col2)
) ENGINE=InnoDB;