Reproduced SET foreign_key_checks=0; Cancel foreign key constraint in MySQL

In MySQL, you cannot delete a table and modify the table structure if a FOREIGN key constraint is established between the table and the table.   The workaround is to cancel the foreign key constraint in MySQL: SET foreign_key_checks=0; Then export the data from the original table to the SQL statement, recreate the table, then import the data using SQL and then set the FOREIGN KEY constraint: set Foreign_key_checks=1;

Reproduced SET foreign_key_checks=0; Cancel foreign key constraint in MySQL