Disabling foreign key checks in MySQL is usefull when you are dealing with tables that use foreign keys (InnoDB engine). You can not delete (drop) multiple tables, a parent table or a child table until you disable foreign key checks four your current database. The sql command to disable foreign key checks is: [sql]SET FOREIGN_KEY_CHECKS …
September 2012 archive
Permanent link to this article: https://blog.openshell.in/2012/09/disable-foreign-key-checks-in-mysql/