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

This article will explain in detail the implementation of IDEA connection to the database, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

[1] add database to the right column

(1.1) first look at the right column to see if there is a [database] icon. From me, we can see that there is no icon.

Select [View]-[Tool Windows]-[Database] as shown in the figure.

As shown in the figure, the [Database] column can be seen in the right column.

[2] create a new database

(2.1) Click the + sign to start preparing for a new link

(2.2) Select the corresponding version of the database, for example: here I choose the Mysql database.

Then fill in your database information in the red box, and then click the [TEST CONNECTION] test link. If the following tick and ping value appear, the link is successful, and then click [OK].

(2.4) then the panel can see your database information.

[3] View tabl

(3.1) expand to see the link information of all tables.

(3.2) if you click on a table, you can see the information in the table.

[4] modify the table

Select a table, right-click, and select [Modify Table...] to modify the table structure.

(4.2) the table structure interface pops up, and the four operations on the right correspond to add, delete, move up, and move down fields.

[5] execute SQL

(5.1) Click the icon shown below

(5.2) Select [New console]

(5.3) then you can get a console that can input and execute SQL.

Then write a SQL casually, and there are also intelligent tips in the process of writing SQL, Ness.

After writing the SQL, click the left triangle button to execute the SQL, and then see the execution result below

On the implementation of IDEA connection to the database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.