Hence, the birth of the MySQL InnoDB vs. MyISAM debate. Of course, MySQL users prior to the 5.5 release were probably perplexed by the assertion that the database didn't support foreign keys. MySQL ...

I'm writing this app in ASP.NET/C#, with a MySQL backend. Should I set up a foreign key constraint? How would I go about doing this within a table (to tie the parentid field to the folderid field)?