vs工具连接到数据库mysql_MySQL-for-VS-Code: Visual Studio Code 的 MySQL 管理工具功能管理 MySQL 连接查看 MySQL 服务器查看 My...

最新推荐文章于 2024-07-26 09:38:33 发布

weixin_39675728

最新推荐文章于 2024-07-26 09:38:33 发布

阅读量225

点赞数

文章标签： vs工具连接到数据库mysql

本文链接：https://blog.csdn.net/weixin_39675728/article/details/114008873

版权

该博客介绍了如何使用VS Code的MySQL管理工具来连接和管理MySQL数据库。用户可以添加连接，查看服务器、数据库、表格和列，并运行MySQL查询。通过右键菜单或快捷键执行SQL，设置中可以调整最大显示表格数。默认开启匿名遥测数据收集，但可以在设置中关闭。

摘要由CSDN通过智能技术生成

MySQL

formulahendry.vscode-mysql.svg vscode-mysql.svg?branch=master

MySQL management tool

Features

Manage MySQL Connections (support SSL connection)

List MySQL Servers

List MySQL Databases

List MySQL Tables

List MySQL Columns

Run MySQL Query

Usage

To add MySQL connection: in Explorer of VS Code, click "MYSQL" in the bottom left corner, then click the + button, then type host, user, password, port and certificate file path (optional) in the input box.

To run MySQL query, open a SQL file first then:

right click on the SQL file, then click Run MySQL Query in editor context menu (Note: you could also run the selected SQL query)

or use shortcut Ctrl+Alt+E

or press F1 and then select/type Run MySQL Query

To create a new MySQL query or change active MySQL connection (You could see active MySQL connection in status bar):

right click on a MySQL server, then click New Query

or right click on a MySQL database, then click New Query

Settings

vscode-mysql.maxTableCount: The maximum table count shown in the tree view. (Default is 500)

Telemetry data

By default, anonymous telemetry data collection is turned on to understand user behavior to improve this extension. To disable it, update the settings.json as below:

{

"vscode-mysql.enableTelemetry":false

}

Change Log

See Change Log here

Issues

Currently, the extension is in the very initial phase. If you find any bug or have any suggestion/feature request, please submit the issues to the GitHub Repo.