mysql外键级联删除示例

1.先建立两个表（用户，音乐）

create table user(
    id int primary key auto_increment,//主键递增
    username varchar(50),
    password varchar(50),
)
create table music(
    id int primary key auto_increment,//主键递增
    music_name varchar(50),
    music_url varchar(50),
)

2.建立一个评论表，外键连接用户与音乐

create table review(
    id int primary key auto_increment,//主键递增
    user_id int,//用户的id
    music_id int,//音乐的id
    review_info varchar(50),
    create_time date,


    constraint fk1 foreign key(user_id)references user(id)
    on delete cascade on update cascade,//创建外键fk1，级联删除与修改

    constraint fk2 foreign key(music_id)references music(id)
    on delete cascade on update cascade,//创建外键fk2，级联删除与修改
)

3.添加数据并进行删除修改，评论表会同步进行级联删除与修改

附一个模板

constraint “该外键名（自己定）” foreign key(“当前表外键字段”)references “外键表”(“外键字段”)
on delete cascade on update cascade,//on delete cascade级联删除，on update cascade级联修改