When multiple tables are joined in mysql to delete data, the associated data is also deleted.

This article shares an article about how to delete joined data when multiple tables are joined and deleted in mysql. For more information, see this article.

This article shares an article about how to delete joined data when multiple tables are joined and deleted in mysql. For more information, see this article.

Category and news ).

The id (column number) Field in category is used as the primary key of the table. It uniquely identifies the information of a column.
The id field in news is used as the primary key of the table. It uniquely identifies the information of a column.

The category_id (column number) field is associated with the id field of the category table.

1. SQL deletion statement

The Code is as follows:
SQL = "delete category, news from category left join news on category. id = news. category_id