Disable foreign key checks in MySQL

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:

SET FOREIGN_KEY_CHECKS = 0;

To  enable the foreign key checks use the opposite command:

SET FOREIGN_KEY_CHECKS = 1;

Published by Cristian Radulescu

PHP // MySql // Linux

Join the Conversation

5 Comments

  1. OMG – that is SO awesome! so much easier to deal with than SQL Server. THANK YOU!!!!

Leave a comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.