MySQL foreign key constraints disabling and enabling command sharing

The following editor will bring you an articleMySQLdisabling and enabling commands for foreign key constraints. The editor thinks it is quite good, so I will share it with you now and give it as a reference for everyone. Let’s follow the editor to take a look

Disabling and enabling MySQL foreign key constraints:

MySQL foreign key Whether the constraint is enabled is indicated by a global variable :

FOREIGN_KEY_CHECKS=0; 禁用状态
FOREIGN_KEY_CHECKS=1; 启用状态

To view the current value of FOREIGN_KEY_CHECKS, you can 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 is the detailed content of MySQL foreign key constraints disabling and enabling command sharing. For more information, please follow other related articles on the PHP Chinese website!