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 ...

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)?