Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I would simply turn off foreign key checks: SET FOREIGN_KEY_CHECKS=0; and make all the changes, and then turn foreign key checks back on: SET FOREIGN_KEY_CHECKS=1;
Answer
#1: Initial revision
by
manassehkatz
·
2020-08-24T20:37:59Z (about 4 years ago)
I would simply turn off foreign key checks:
SET FOREIGN_KEY_CHECKS=0;
and make all the changes, and then turn foreign key checks back on:
SET FOREIGN_KEY_CHECKS=1;