// ON DELETE CASCADE 级联删除
//表user
create table user(
id int not null primary key,
name varchar(20) not null
)engine=innodb
//表 userinfo
create table userinfo(
id int not null,
// ON DELETE CASCADE 级联删除
//表user
create table user(
id int not null primary key,
name varchar(20) not null
)engine=innodb
//表 userinfo
create table userinfo(
id int not null,