MySQL 同时 delete 多张表的数据

create tablearticle(
    article_id int primary keyauto_increment,
    article_title varchar(100)
);
insert into article(article_title) values('Spring源码分析'),
('Spring生命周期'),
('SpringMVC源码分析'),
('MySQL....');

create tabletag(
    tag_id int primary keyauto_increment,
    tag_name varchar(100)
);
insert into tag(tag_name) values('Spring'),
('SpringMVC'),
('Java'),
('MySQL');

create tablearticle_tag(
    article_tag_id int primary keyauto_increment,
    article_id int,
    tag_id int);
insert into article_tag(tag_id,article_id) values(1,1),
(1,2),
(2,2),
(3,1),
(3,2),
(3,3),
(4,4);

# 删除 文章id 为 2的相关数据
DELETEarticle_tag,
article 
FROMarticle_tag
    INNER JOIN article ON article_tag.article_id =article.article_id 
WHEREarticle.article_id = 2;