准备数据表
存在两张表websites 和 apps
create table websites (
id int primary key auto increment,
name varchar(255) not null,
url varchar(255) not null,
alexa int not null,
country varchar(20) not null
) engine = innodb
default charset = utf8mb4
comment = '站点表';
create table apps (
id int primary key auto increment,
app_name varchar(255) not null,
url varchar(255) not null,
country varchar(20) not null
) engine = innodb
default charset = utf8mb4
comment = "app表";
创建数据
insert into websites(id, name, url, alexa, country) values
(1, 'google', 'www.google.com', 1, 'usa'),
(2, '淘宝', 'www.taobao.com', 13, 'cn'),
(3, '菜鸟教程', 'www.runoob.com', 4689, 'cn'),
(4, '微博', 'www.weibo.com', 20, 'cn'),
(5, 'facebook', 'www.facebook.com', 3, 'usa'),
(6, 'stackoverflow', 'www.stackoverflow.com', 0, 'ind');
insert into apps(id, app_name, url, country) values
(1, 'qq app', 'www.qq.com', 'cn'),
(2, '微博 app', 'www.weibo.com', 'cn'),
(3, '淘宝 app', '