查看所有表
!table
查看表结构
!desc table_name
创建schema(相当于数据库)
create schema cg;
创建表
create table if not exists cg.company(id bigint primary key,name varchar(20),address varchar(100));
插入数据
upsert into cg.company(id,name,address) values(20,'xuxiao','德国柏林')
upsert into cg.company (id,name,address) values (1, '阿里', '杭州')
upsert into cg.company (id,name,address) values (2, '百度', '北京')
upsert into cg.company (id,name,address) values (3, '腾讯', '深圳')
upsert into cg.company (id,name,address) values (4, '小米', '武汉')
upsert into cg.company (id,name,address) values (5 ,'捷越', '北京')
upsert into cg.company (id,name,address) values (6, '向前向未来', 'http://www.fowardfuture.com/')
查询插入数据
select * from cg.company
创建视图
create view cg.view_user_all as
select * from cg.company ;