MySQL图形界面软件-Navicat

Dear 丶 2024-04-06 13:00 56阅读 0赞

**目录**

一、关于Navicat

二、软件安装

2、获取永久许可证

三、Navicat的使用

1、连接数据库

2、创建、删除数据库

2.1、新建数据库

2.2、删除数据库

3、创建表、及表内容的增删改查

3.1、新建表

3.2、表内容的增、删、改、查

4、数据库的备份与恢复

4.1、数据库的备份

4.2、 恢复数据库

--------------------

## 一、关于Navicat ##

Navicat是一款强大的数据库管理和设计工具，支持通过直观的GUI对MySQL、PostgreSQL、Oracle、MariaDB等数据进行管理。从Navicat 15版本开始支持通过创建数据源连接实现数据可视化设计和分析。目前最新版本为16，支持常见数据可视化效果设计以及仪表板设计。

作为技术人员自己或小范围项目组内辅助监控分析手段，Navicat已有的可视化能力基本可满足需求， 学习成本低、实施风险小，对工作能效提升明显

## 二、软件安装 ##

下载：

[https://download.csdn.net/download/m0\_62948770/86721073][https_download.csdn.net_download_m0_62948770_86721073]

1、安装

![b8bacbc47cca4476a7db89e673611ee1.png][]

![956dbd34c7a44eef9cd2fc36d050d890.png][]

![9a7a71c69c8a4139af818990d1f8173c.png][]

![85256769f7fc4fb1accfa7af43846128.png][]

![c89e4748f0c34bce838cea27663f83d9.png][]

![75fda917d8004b2a95d69b95f666ee82.png][]

![a168c88de1e24e198bfa0a8175248ee3.png][]

![30bfdec7542441eb8f12bd579d960a4a.png][]

**注意：安装完成之后千万不要运行软件，否则就无法获取永久许可证了。**

### 2、获取永久许可证 ###

**①点击获取永久许可证的 软件**

![3a90cde4893a4d93b851526cfe5e701c.png][] ![7610df1a2a1441bf878a92baea49bbec.png][]

**②选择选项**

![e4eb8ed1055b489396792e31fa7e03ee.png][]**③出现下面的表示导入数据成功**

![1cf2ec39982f458d8dfd6f6103c29591.png][]

**④生成激活码，并复制**

![530b7f90c6104a558457c4dd351b55c7.png][]

**⑤打开Navicat Premium 12**

![9743cc4724b14e9e8400afc2d003d3bd.png][]

点击注册 ![c2b85f621c5049f5a6ad1312ad3ae9a7.png][]

把刚复制的激活码粘贴到永久许可证中

![4da759a6e9ea475f8d12b04fe440dee2.jpeg][] ![521d4f9d7642482bacfe06f94d3b8190.jpeg][]

![549221bc047d47ac8afae838a1e41dda.png][]

激活完成。

## 三、Navicat的使用 ##

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

第一步：

![ee5dda25e3c34cd8840d28d76d62ca0f.png][]

第二步：

![2a1141c2743d4019938cff16580708f7.png][]

### 2、创建、删除数据库 ###

#### 2.1、新建数据库 ####

![5a24417a15364d0f8d7ef2935f66ec8c.png][]

![863f825fe1c245db9a4fce96cc7db825.png][]

#### 2.2、删除数据库 ####

![015efb06d09641aaa06b7e8d71e78f8a.png][]

### 3、创建表、及表内容的增删改查 ###

#### 3.1、新建表 ####

![25b5361a140245c6ac0e8f4251a75df5.png][]

![832633683bad48a796a5c97f9f68c371.png][]

#### 3.2、表内容的增、删、改、查 ####

**增：**

![b8a7e05602c4488e8f682f10cd24fff0.png][] ![368e0696de04406e802b444d0d282b38.png][]

**删：**

![a61f6e43051b4d31bc095941a08f9855.png][]

**改：**

直接双击修改的内容就可修改

**查：**

![530f267a80ee4927ab40fc1e8685e198.png][]

![2bca524bd96c44e6ad74b43189238326.png][]

### 4、数据库的备份与恢复 ###

#### 4.1、数据库的备份 ####

![3e5a976f28e24e4bb037863f40dfa71b.png][]

![4841a2b3ce3b498c805a12122bc9da47.png][]![2bc297381b1a458690b9d7b984a6448c.png][]

![8e30a33d6c5f430e956d5e2b706f60d8.png][]

#### 4.2、 恢复数据库 ####

![0817ad6e5aa2438895dffbb1a5326fed.png][]

![b3464833e1f948c3a706cd000d289261.png][]

![4a2bbf02211c4b28a69386e31d8bcbf0.png][]![9fa25efffc96481fbff81aaf63540de2.png][] ![3c542d8031c94c2c9b6b22b870a860f0.png][]

![42899406da414466bc79abbb3c62c83f.png][]

验证：

![4b7bd1aa488a4af9b2c5a831e72389ed.png][]

数据库恢复成功

[https_download.csdn.net_download_m0_62948770_86721073]: https://download.csdn.net/download/m0_62948770/86721073
[b8bacbc47cca4476a7db89e673611ee1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/c3ea63baabf94443909e84beb469c209.png
[956dbd34c7a44eef9cd2fc36d050d890.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b81a314be34249a98cd7f302c5d42f96.png
[9a7a71c69c8a4139af818990d1f8173c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b4cf67bd99354145993f873abf83d2fd.png
[85256769f7fc4fb1accfa7af43846128.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/62790a78ea3b4a14aec5c10581d7e758.png
[c89e4748f0c34bce838cea27663f83d9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f49984f3ec84412a81c66bd42ba9a28d.png
[75fda917d8004b2a95d69b95f666ee82.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/7fd25c536f0c4f2f92c2dcd5e8181b1e.png
[a168c88de1e24e198bfa0a8175248ee3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f2b571ca77264c20bcf3522e64154e0a.png
[30bfdec7542441eb8f12bd579d960a4a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/c65041a0d4bc4e688811f18e37d86960.png
[3a90cde4893a4d93b851526cfe5e701c.png]: https://img-blog.csdnimg.cn/3a90cde4893a4d93b851526cfe5e701c.png
[7610df1a2a1441bf878a92baea49bbec.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/1c39faf5374e4411abcd2f7de2d4e3b9.png
[e4eb8ed1055b489396792e31fa7e03ee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/0403bd19068e4179a7997a64916e43a8.png
[1cf2ec39982f458d8dfd6f6103c29591.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b8e11244eb98440a9733191935b9de93.png
[530b7f90c6104a558457c4dd351b55c7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/a3b095e14a814594bb584f2fa2f4c060.png
[9743cc4724b14e9e8400afc2d003d3bd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/e64a2b751cf24ae3a5742ea7a6b4716a.png
[c2b85f621c5049f5a6ad1312ad3ae9a7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f202c1137e1b438daa743c7eee64afde.png
[4da759a6e9ea475f8d12b04fe440dee2.jpeg]: https://img-blog.csdnimg.cn/4da759a6e9ea475f8d12b04fe440dee2.jpeg
[521d4f9d7642482bacfe06f94d3b8190.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/912db739c6e2479c89d3756ba948e37a.jpeg
[549221bc047d47ac8afae838a1e41dda.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/a08b9db6000e4108aba11a288a7eebdf.png
[ee5dda25e3c34cd8840d28d76d62ca0f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/68b119f6e7df46fd893ef3d11e85813e.png
[2a1141c2743d4019938cff16580708f7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ada13cd0295948e6a3f2e5fb7832c966.png
[5a24417a15364d0f8d7ef2935f66ec8c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/172f489de97345efb4ada9e2290bf638.png
[863f825fe1c245db9a4fce96cc7db825.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/3008014ad6174cada3dfa1e0a0451c42.png
[015efb06d09641aaa06b7e8d71e78f8a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/dd78e2a2bb594d9f8fa862af53890e83.png
[25b5361a140245c6ac0e8f4251a75df5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/31dca5d600594b1ab68ecbf1d3d745db.png
[832633683bad48a796a5c97f9f68c371.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/0fa9efc5f9014072b7ca8d20ac15cd96.png
[b8a7e05602c4488e8f682f10cd24fff0.png]: https://img-blog.csdnimg.cn/b8a7e05602c4488e8f682f10cd24fff0.png
[368e0696de04406e802b444d0d282b38.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/1d2629ec932042d784665bd59ec327ac.png
[a61f6e43051b4d31bc095941a08f9855.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/5444038713354aa99a62d7e459455c26.png
[530f267a80ee4927ab40fc1e8685e198.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/8df8453106e8495eb5398238804dee91.png
[2bca524bd96c44e6ad74b43189238326.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/776e2026a23a4268bd1fe6d40f498429.png
[3e5a976f28e24e4bb037863f40dfa71b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/9a943ad02064411fa03c42d008c94261.png
[4841a2b3ce3b498c805a12122bc9da47.png]: https://img-blog.csdnimg.cn/4841a2b3ce3b498c805a12122bc9da47.png
[2bc297381b1a458690b9d7b984a6448c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/1f0f29f059ac4cf19b39f1f8031d7eaf.png
[8e30a33d6c5f430e956d5e2b706f60d8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/9085f25f55c049fe8908d65daa851e40.png
[0817ad6e5aa2438895dffbb1a5326fed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/54429e4210704165872bdb432bef91aa.png
[b3464833e1f948c3a706cd000d289261.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6df5a10f0f1446f981c5ebe9b27bdae0.png
[4a2bbf02211c4b28a69386e31d8bcbf0.png]: https://img-blog.csdnimg.cn/4a2bbf02211c4b28a69386e31d8bcbf0.png
[9fa25efffc96481fbff81aaf63540de2.png]: https://img-blog.csdnimg.cn/9fa25efffc96481fbff81aaf63540de2.png
[3c542d8031c94c2c9b6b22b870a860f0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ccf309d719a9427e8e985de7718fd7c8.png
[42899406da414466bc79abbb3c62c83f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ef7483e795f949ada63c8a94e229cb74.png
[4b7bd1aa488a4af9b2c5a831e72389ed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/d865b259c1df4e129c0b726b0e1a4f58.png