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 optimization key #3: No defaults! Like any software, MySQL has many configurable settings that can be used to modify behavior (and ultimately, performance).