Use Visual Studio Code to connect to the MySql database and query

Visual Studio Code is a powerful text editor produced by Microsoft. This article introduces how to use VS Code to connect to the MySql database and execute queries.

How to use

Step 1. Install Visual Studio Code

VS Code is a cross-platform text editor. You can download and install it by visiting the VS Code official website or installing the local green version.

Step 2. Open VS Code and install the plugin

Install the plugin:

MySQL

MySQL Syntax

Step 3. Start using

In the file menu you can add a database connection:

Follow the steps to fill in the server, user name, password, etc.:

Connection successful:

Right click to execute the query:

After writing the SQL script, you can right-click to execute it:

Execution Result:

Disconnect from the database:

This is the end of this article about using Visual Studio Code to connect to MySql database and query. For more related VS Code connection to MySql and query content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!