Toggling foreign key checks in MySQL

Recently in my project, we needed to import database dumps of a legacy database in MySQL, which was involved in a nested relationship where one tuple could be the parent record of another tuple. We created the appropriate domain structure and checked that the foreign key references were created accordingly. All well and good. So we...

by Roni C. Thomas
Tag: foreign key check