Hbase------刘飞

建库

CREATE DATAbase dbtest DEFAULT CHARSET utf8;
USE dbtest;

建表

CREATE TABLE IF NOT EXISTS websites(id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAr(50) NOT NULL,
url VARCHAr(50) NOT NULL,
alexa INT NOT NULL COMMENT "网站排名",
country VARCHAr(20) NOT NULL
);

CREATE TABLE IF NOT EXISTS access_log(
    aid INT PRIMARY KEY AUTO_INCREMENT,
    site_id INT NOT NULL,
    COUNT INT DEFAULT 0,
    DATE DATE
);

删

删除websites的表

CREATE DATAbase websites;

增

增加数据

INSERT INTO websites(NAME,url,alexa,country)VALUES
("google","https://www.goole.com",1,"usa"),
("淘宝","https://www.taobao.com",13,"cn"),
("菜鸟","http://www.runoob.com",16,"cn"),
("微博","http://www.weibo.com",20,"cn"),
("facebook","http//www.facebook.com",3,"usa"),
("stackovarflow","http//www.stackovarflow.com",2,"usa"),
("百度","http//www.baidu.com",4,"cn");

INSERT INTO access_log(site_id,COUNT,DATE)VALUES
(1,45,"2016-05-10"),
(2,100,"2016-05-10"),
(5,415,"2016-05-10"),
(5,200,"2016-05-10"),
(6,7,"2016-05-10"),
(7,145,"2016-05-10"),
(8,45,"2016-05-10"),
(9,545,"2016-05-10"),
(10,201,"2016-05-10");

改

把改google排名改为第2

update websitesset alexa =1;

update websitesset alexa =2 NAME ='google';

查

查找websites

select * from websites;

#内连接...inner join...on
USE web;
SELECt * FROM websites w INNER JOIN access_log a ON w.id=a.site_id;
SELECt * FROM websites w,access_log a WHERe w.id=a.site_id;
#全连接=左连接 union 右连接
SELECt * FROM websites w LEFT JOIN access_log a ON w.id=a.site_id
UNIOn
SELECt * FROM websites w RIGHT JOIN access_log a ON w.id=a.site_id;

#左连接 left join...on
SELECt * FROM websites w LEFT JOIN access_log a ON w.id=a.site_id;
#右连接 right join...on
SELECt * FROM websites w RIGHT JOIN access_log a ON w.id=a.site_id;