MySQL视图

1. 准备数据

1. 创建三个数据表
   用户表，存储用户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);
2. 插入数据
   用户数据
   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