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 InnoDB and transactions Transactional support is a key difference between MySQL InnoDB vs. MyISAM. If a problem occurs when you write data to an InnoDB engine, you can roll back any changes to ...