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

Editor to share with you how to connect to the mysql database in vscode. I hope you will gain a lot after reading this article. Let's discuss it together.

Vs code connects to mysql database

1. Development tool vs code

2. Computer system windows 10 Professional Edition

3, in the process of development, we often use the database, in order to save space, in order to reduce the installation of other programs, I choose the development tool is vs code, the database is mysql. I'm going to talk about how vs code connects to the mysql database.

4. First install the corresponding plug-in:

MySQL / MySQL Syntax

4-1: after the installation is complete, click mysql in the following figure

4-2: then fill in the corresponding information:

4-3: after filling in the corresponding information, we probably get a result like this:

4-4: view the data of a table under the database as follows: (right-click and select select top 1000)

4-5: right-click the select top 1000 of a table, and the results are as follows:

/ / after writing the sql statement, how to execute it? The shortcut key is ctrl+alt+e

The above is method one, and method two is as follows.

5. Install the plug-in:

Vscode-database

5-1: after installing the plug-in

5-2: after filling in the corresponding information, click the link. When the connection is successful, you will see the following:

5-3: click that icon:

5-4: do the following:

5-5: select the database:

5-6: the corresponding tables under the associated database:

5-7: query the data of the table.

6. The tutorial of this issue ends here. Does it feel very helpful? I hope it will be helpful to you. Let's work hard to reach the peak.

After reading this article, I believe you have a certain understanding of the method of connecting to the mysql database in vscode. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.