如何在MySQL中删除具有循环外键的表

I have two tables, Parent and Child. The column Parent.favorite_child has a foreign key constraint pointing to Child.id. And the column Child.parent has a foreign key constraint pointing to Parent.id.I have two tables, Parent and Child. The column