- 准备数据
- 创建三个数据表
用户表,存储用户id、用户名、电话、所属省id、所属市id
create table user( id int unsigned not null primary key auto_increment, user_name varchar(20) not null unique, phone varchar(11) not null unique, province_id int not null, city_id int not null );
省份表,存储省份id和省份名
create table province( id int unsigned not null primary key auto_increment, name varchar(20) not null unique);
市区表,存储市区id和城市名
create table city( id int unsigned not null primary key auto_increment, name varchar(20) not null unique);
- 插入数据
用户数据
insert into user values(0,'laowang',110,1,1),(0,'laoli',111,1,2),(0,'laozhao',112,1,3),(0,'xiaowang',114,2,5),(0,'xiaosun',115,2,5),(0,'laoxin',116,2,5),(0,'xiaoliu',117,2,4),(0,'laoliu',118,2,5),(0,'xiaozhang',119,2,4);
省份数据
INSERT INTO prov