I read something that made it seem as though InnoDB foreign keys can reference anything: primary keys, unique keys, and even non-unique columns...have I interpreted this correctly?
What do MySQL's other storage engines like MyISAM allow for what foreign keys can reference? Can they reference anything, or just primary keys, or primary keys as well as unique keys?
Thanks.