#视图
VIEW
#默认
DEFAULT
#使用库
USE hbase;
#创建表并判断表是否已存在
CREATE TABLE IF NOT EXISTS author(
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
author_name VARCHAR(255) DEFAULT NULL
);
SELECT * FROM author;
#插入数据
INSERT INTO author(author_name)
VALUES("Naame"),
("Lucy"),
("Lily"),
("Jack");
#创建表2并判断表是否已存在
CREATE TABLE IF NOT EXISTS blog(
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
title VARCHAR(50) DEFAULT NULL, #默认为空
content VARCHAR(100) DEFAULT NULL,
author_id INT DEFAULT NULL
);
#插入数据
INSERT INTO blog(title,content,author_id)
VALUES("测试博客1","博客内容111",1),
("测试博客2","博客内容222",2),
("测试博客3","博客内容333",3),
("测试博客4","博客内容444",4);
#创建视图(虚拟的,临时存在的)
CREATE VIEW v_author(编号,姓名)
AS
SELECT * FROM author WITH CHECK OPTION;
#查询视图
SELECT * FROM v_author;
#任务:多表视图
CREATE VIEW v_author1(编号,姓名,博客主页)
AS
SELECT a.*,b.content FROM author a,blog b WHERE a.id=b.id;
#查询视图
SELECT * FROM v_author1;
SELECT * FROM sub;