DBeaver

测试环境

测试范围

• 连通性

• 列举数据库

• 创建表

  
  DROP TABLE IF EXISTS `school`;
  CREATE TABLE `school` (
    `id` bigint NOT NULL,
    `name` varchar,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    key status_idx(`name`),
    primary key (id)
  ) DISTRIBUTE BY HASH(`id`);

• 列举所有表

• 查看表结构

  
  show create table school;
  
  -- 查询结果:
  -- Table: school
  -- Create Table: Create Table `school` (¶ `id` bigint NOT NULL,¶ `name` varchar,¶ `create_time` timestamp NOT N...

  

• 向表中写入数据

• 查看表数据

• 创建视图

  
  CREATE VIEW `school_view` as select * from school;
  
  Statistics:
  Updated Rows: 0
  Query: CREATE VIEW `school_view` as select * from school
  Finish time: Tue Nov 19 16:45:56 CST 2019

• 查看视图结构

  
  SHOW CREATE VIEW school_view;
  
  -- 结果:
  -- View: school_view
  -- Create View: CREATE VIEW `test4dmp`.`school_view` AS SE...
  -- character_set_client: utf8
  -- collation_connection: utf8_general_ci

  

• 查询视图