数据库可视化工具 dbForge Studio for MySQL 快速入门以及进阶指导

Bertha 。 2022-12-29 11:23 92阅读 0赞

**dbForge是个很优秀的数据库可视化工具**

**目前是我用过唯一可以断点调试sql语句的软件**

**以下对dbForge的一些基本操作和进阶操作做个说明与记录**

# 一、入门操作 #

### 1、连接数据库 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70][]

### 2、当前连接信息面板添加&切换操作数据库 ###

### ![2020122214145927.png][] ###

**或者**

![20201222142038659.png][]

### 3、切换数据卡片视图 ###

网格视图（grid view）和 卡片视图switch to card view 切换

![20201222114720949.gif][]

### 4、dbForge Studio 打开 SQL编辑器 ###

![20201222120643276.png][]

### 5、SQL编辑器快捷面板添加 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1][]

### 6、查询sql执行历史列表 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 2][]

# 二、进阶操作 #

### 1、快速生成增删改查sql ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 3][]

## ##

### 2、快捷键定义 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 4][]

常用快捷键

sql 注释：commentCode

sql 取消注释：UncommentCode

### 2、sql编辑器功能(格式化，注释，取消注释，调整缩进) ###

**按照  《5、SQL编辑器快捷面板添加》添加 text面板即可**

![20201228104239235.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70]: /images/20221120/4bb5fd9c2bbc4c1a85d00b1516215fd0.png
[2020122214145927.png]: /images/20221120/bbbd79db23a442a9b821fc949dce7dcc.png
[20201222142038659.png]: https://img-blog.csdnimg.cn/20201222142038659.png
[20201222114720949.gif]: https://img-blog.csdnimg.cn/20201222114720949.gif
[20201222120643276.png]: https://img-blog.csdnimg.cn/20201222120643276.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201222135613795.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201222135753189.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20201222142617561.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201228103304571.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY=,size_16,color_FFFFFF,t_70
[20201228104239235.png]: https://img-blog.csdnimg.cn/20201228104239235.png