Introduction to MySQL method of deleting table data with foreign key constraints

When deleting a table or a piece of data in MySQL,

[Err] 1451 -Cannot delete or update a parent row:
 aforeignkeyconstraintfails(...)

This is because a foreign key association is set in MySQL, which makes it impossible to update or delete data. This can be avoided by setting the FOREIGN_KEY_CHECKS variable.

To disable foreign key constraints, we can use:

SETFOREIGN_KEY_CHECKS=0;

Then delete the data

To enable foreign key constraints, we can use:

SETFOREIGN_KEY_CHECKS=1;

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

SELECT @@FOREIGN_KEY_CHECKS;

Summarize

The above is all the content of this article about how to delete table data with foreign key constraints in MySQL. I hope it will be helpful to everyone. Interested friends can refer to: How to delete table data in MySQL, Analysis of MySQL variable declaration and stored procedure, Several important MySQL variables, Detailed explanation of MySQL prepare principle, etc. If you have any questions, please leave a message at any time and the editor will reply to you in time.