About MySQL Cascade Delete (many people have consulted me before)

Many recent projects have consulted MySQL for cascading removal issues. Do a systematic literacy here.

What is a cascade delete.

That is, depending on the foreign key relationship, when you delete the parent table, you delete the child tables that depend on the table independently.

Two how to do cascade delete

In fact, it is very simple to explicitly specify when the table needs to be established, the properties of the foreign key dependency relationship are allowed to cascade Delete.

On DELETE CASCADE

Iii. What are the pros and cons of using cascade deletions

The advantages are obvious, the program removal time is simple.

The disadvantage is also obvious, the business design time to do the deletion when considering the need for higher requirements. Otherwise prone to problems.

About MySQL Cascade Delete (many people have consulted me before)