How to enable or disable the foreign key constraint in mysql.

How to enable or disable the foreign key constraint in mysql.
Method for starting and disabling foreign key constraints in mysql (FOREIGN_KEY_CHECKS)

When a table or a piece of data is deleted in MySQL

[Err] 1451-Cannot delete or update a parent row: a foreign key constraint fails (...)

This is because the foreign key Association is set in MySQL, and data cannot be updated or deleted. You can set the FOREIGN_KEY_CHECKS variable to avoid this situation.

To disable the foreign key constraint, we can use:

SET FOREIGN_KEY_CHECKS = 0;

To start the foreign key constraint, we can use:

SET FOREIGN_KEY_CHECKS = 1;

To view the current FOREIGN_KEY_CHECKS value, run the following command:

SELECT @ FOREIGN_KEY_CHECKS;