Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.

MySQL will soon store FOREIGN KEY definitions so that a client can ask for and receive an answer about how the original connection was made. The current `.frm' file format does not have any place for ...