话不多说直接上代码
省市级联动
create table Provice(
pid int primary key auto_increment,
pname varchar(50)
);
INSERT into provice VALUES(null,'四川');
create table city(
cid int primary key auto_increment,
cname varchar(50),
pid int,
foreign key(pid) references provice(pid)
);
create tablE COUNTY(
CCid int primary key auto_increment,
CCname varchar(50),
cid int,
foreign key(cid) references city(cid)
);