Shulou(Shulou.com)06/01 Report--

This article mainly shows you "what a tool DBeaver is". The content is simple and clear. I hope it can help you solve your doubts. Let the editor lead you to study and learn this article "what is DBeaver?"

Overview of DBeaver

DBeaver is an open source database management tool based on Java development and supports almost all database products.

DBeaver Community Edition supports not only relational databases such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, Db2, SQL Server, but also embedded databases such as SQLite and H2. It also supports common full-text search engines such as Elasticsearch and Solr, big data-related tools such as Hive and Spark.

Overview of databases supported by DBeaver

Even the commercial version of DBeaver supports a variety of NoSQL databases.

The commercial version of DBeaver also supports the use of various NoSQL databases

Although DBeaver is small, it is still very powerful. Basic table design, SQL execution, ER diagrams, data import and export, and other common functions are out of the question.

I'll just briefly demonstrate the creation of a basic database and a table.

Download and install

The official website provides the download address: https://dbeaver.io/download/, you can choose the appropriate version to download and install according to your operating system.

It's relatively simple, so I won't demonstrate it here.

Connect to the database

1. Select the database you want to connect to, and then click next (you may need to download the driver for the first connection).

Let me take MySQL as an example.

two。 Enter the address, user name and password of the database, and then click finish to connect.

Before clicking finish, you can check the test connection at the bottom left to see if the database can be connected successfully.

Create a new database

Right-> create a new database (MySQL users remember to use utf8mb4 instead of utf8)

Database table related operations new table new column creation constraints (primary key, unique key)

Insert data

We insert data through the SQL editor:

INSERT into user (id,name,phone,password) values ('A00001' recording 'Guidege', '181631312315' recording '123456')

INSERT into user (id,name,phone,password) values (181631312313) values ('A00002)

INSERT into user (id,name,phone,password) values (181631312312)

The above is all the content of this article "what is DBeaver?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.