DBeaver supports the following commands: Command Database Description @set var = value All Sets a script variable. You can use expressions as a value. Variables can be used as SQ...

You might need to disconnect from a database to free up resources or close transactions. To disconnect from a database, in the Database Navigator or Projects view, click the con...

DDL（Data Definition Language，数据定义语言）语句用来创建、修改和删除数据库对象。在 DDL 开始之前和之后，OceanBase 数据库会发出一个隐式的 COMMIT 语句，所以不可以回滚 DDL 语句。 说明 在 obclient 命令行环境下，可以在“SQL提示符>”后输入 DDL 语句。 在 DBeaver 的 SQ...

DML（Data Manipulation Language，数据操作语言）语句可以操作表中的数据，如增加、修改、删除等。 说明 在obclient命令行环境下，可以在“SQL提示符>”后输入DML语句； 在DBeaver的SQL编辑器窗口，也可以输入DML语句。 DML语句对数据的修改效果只有在提交事务时才永久生效。一个事务是一序列被O...

SQL Client Applications SQL Client Applications Thanks to its JDBC and ODBC interfaces, a broad range of third-party applications can use Elasticsearch SQL capabilities. Thi...

To be able to manage your database in DBeaver, you need to create a connection to this database – see Creating Connections . A connection includes a driver and a number of configu...

To search for database metadata, click the arrow next to the Search button in the main toolbar and then click DB Metadata Search on the dropdown menu: Alternatively, you can ...

Views are windows within the workspace that provide presentations and ways to navigate the information.The main views in DBeaver are: Database Navigator , Projects and Project Ex...

Analyze historical intraday stock data Prerequisites Get started: create a virtual environment Analyze historical intraday stock data This tutorial is a step-by-step guide on ...

DDL（Data Definition Language，数据定义语言）语句用来创建、修改和删除数据库对象。在 DDL 开始之前和之后，OceanBase 数据库会发出一个隐式的 COMMIT 语句，所以不可以回滚 DDL 语句。 说明： 在 obclient 命令行环境下，可以在“SQL提示符>”后输入 DDL 语句。 在 DBeaver 的 ...