MySQL foreign key constraint disable and enable commands

Disabling and enabling MySQL foreign key constraints:

Whether MySQL foreign key constraints are enabled is indicated by a global variable:

FOREIGN_KEY_CHECKS=0; Disabled

FOREIGN_KEY_CHECKS=1; Enabled

To view the current value of FOREIGN_KEY_CHECKS, use the following command:

SELECT @@FOREIGN_KEY_CHECKS;

Disable foreign key constraints:

SET FOREIGN_KEY_CHECKS=0;

Enable foreign key constraints:

SET FOREIGN_KEY_CHECKS=1;

The above disabling and enabling commands of MySQL foreign key constraints are all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.