navicat 结合快捷键

navicat 结合快捷键

1.ctrl+q 打开查询窗口
2.ctrl+/ 注释sql语句
3.ctrl+shift +/ 解除注释
4.ctrl+r 运行查询窗口的sql语句
5.ctrl+shift+r 只运行选中的sql语句
6.F6 打开一个mysql命令行窗口
7.ctrl+l 删除一行
8.ctrl+n 打开一个新的查询窗口
9.ctrl+w 关闭一个查询窗口

10.ctrl+d 在查询表数据界面打开一个该表结构的窗口

<wbr><h3 class="title pre fs1"><span style="background-color:rgb(255,255,255)">navicat我觉得做程序的基本上都会用，它方便，快捷，直观等，优点很多，这也是我写这篇文章的原因。以前我基本上都是用phpmyadmin，也挺好用，不过也有不少缺点，比如数据库备份文件太大，根本没法用导入，多数据库服务器管理，还要去配置phpmyadmin，其实挺不爽的。navicat对于刚用的人来说，其实也不是很方便，但是用熟就不一样了。下面就如何结合快捷键的方式，让navicat用着更舒服。</span></h3> <div class="bct fc05 fc11 nbw-blog ztag js-fs2"> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span id="more-1244" style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"></span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">一，navicat如何写sql语句查询？</strong></span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">方法1：<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">ctrl+q</strong></span>就会弹出一个sql输入窗口，就可以在里面写sql了。写完sql后，直接<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">ctrl+r</strong></span>就执行sql了。还有一点，写sql语句时，<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">navicat会提示的，根代码补全差不多</strong></span>，挺爽的。</span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">方法2：按<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">f6</strong></span>会弹出一个命令窗口，就根mysql -u mysql -p进去时操作一样,<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">不过\G用的时候会报错</strong></span>。在这里也可以查询。</span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">小技巧：这些窗口，可以拖动到一起的，看下图片</span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> </p> <div id="attachment_1245" style="border-bottom:rgb(178,178,178) 1px solid; text-align:center; border-left:rgb(178,178,178) 1px solid; padding-bottom:0px; line-height:18px; margin:0px; padding-left:0px; outline-width:0px; width:310px; padding-right:0px; font-family:Arial,Tahoma,Verdana; max-width:100%; font-size:13px; vertical-align:baseline; border-top:rgb(178,178,178) 1px solid; border-right:rgb(178,178,178) 1px solid; padding-top:0px"> <a href="http://blog.51yip.com/wp-content/uploads/2011/04/navicat_win.jpg" rel="nofollow" style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><span style="color:#000000; background-color:rgb(255,255,255)"><img alt="navicat 多窗口切换" src="http://blog.51yip.com/wp-content/uploads/2011/04/navicat_win-300x90.jpg" width="300" height="90" style="padding-bottom:0px; margin:11px 3px 0px 0px; padding-left:0px; outline-width:0px; padding-right:0px; clear:left; vertical-align:baseline; padding-top:0px"></span></a> <p style="padding-bottom:5px; line-height:15px; border-right-width:0px; margin-top:0px; outline-width:0px; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:11px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">navicat 多窗口切换</span></p> </div> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">上图中有二个窗口，我们可以通过，快捷键<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">ctrl+tab</strong></span>，在窗口间进行切换。</span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">二，navicat如何备份，还原数据库，以及表？</strong></span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">方法1：右击数据名=》选中<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">dump sql file</strong></span>就可以备份，如果要还原，就选<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">execute sql file</strong></span>就行了。备份表，根备份数据库一样操作。还原表，就用import wizard就行了。这种备份导出来的只能是.sql文件。如果想备份成其他文件格式，看方法 2.</span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">方法2：点击数据库，在点上方的<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">export wizard</strong></span>就会弹出一个窗口，<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">让你选择备份成什么样的文件</strong></span>，下一步</span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> </p> <div id="attachment_1246" style="border-bottom:rgb(178,178,178) 1px solid; text-align:center; border-left:rgb(178,178,178) 1px solid; padding-bottom:0px; line-height:18px; margin:0px; padding-left:0px; outline-width:0px; width:310px; padding-right:0px; font-family:Arial,Tahoma,Verdana; max-width:100%; font-size:13px; vertical-align:baseline; border-top:rgb(178,178,178) 1px solid; border-right:rgb(178,178,178) 1px solid; padding-top:0px"> <a href="http://blog.51yip.com/wp-content/uploads/2011/04/navicat_database.jpg" rel="nofollow" style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><span style="color:#000000; background-color:rgb(255,255,255)"><img alt="navicat 备份数据库，以及表" src="http://blog.51yip.com/wp-content/uploads/2011/04/navicat_database-300x119.jpg" width="300" height="119" style="padding-bottom:0px; margin:11px 3px 0px 0px; padding-left:0px; outline-width:0px; padding-right:0px; clear:left; vertical-align:baseline; padding-top:0px"></span></a> <p style="padding-bottom:5px; line-height:15px; border-right-width:0px; margin-top:0px; outline-width:0px; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:11px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">navicat 备份数据库，以及表</span></p> </div> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">如果表太多，用这种方法备份，实在是不方便。如果是导入的话就用<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">import wizard</strong></span>就行了。备份表同样的操作。</span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">三，如何查看表数据和表结构？</strong></span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">双击表就可以查看表数据了，<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">ctrl+d</strong></span>不光可以看到表结构，还可以看到索引，外键，触发器等。</span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">四，如何管理多个mysql服务器？</strong></span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">点击左上方的<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">connection</strong></span>按钮，多连接几个就行了。</span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="padding-bottom:0px; border-right-width:0px; background-color:rgb(255,255,255); margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">五，如何用navicat对数据库管理员进行管理？</strong></span></p> <p style="line-height:18px; border-right-width:0px; padding-left:30px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">点击左上方<span style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px"><strong style="padding-bottom:0px; border-right-width:0px; margin:0px; padding-left:0px; outline-width:0px; padding-right:0px; border-top-width:0px; border-bottom-width:0px; vertical-align:baseline; border-left-width:0px; padding-top:0px">manage users</strong></span>就会弹出一个窗口，里面会列出所有的mysql管理员。修改权限后，保存就行了。</span></p> <p style="line-height:18px; border-right-width:0px; outline-width:0px; font-family:Arial,Tahoma,Verdana; margin-bottom:0px; border-top-width:0px; border-bottom-width:0px; font-size:13px; vertical-align:baseline; border-left-width:0px"> <span style="background-color:rgb(255,255,255)">上面5点，只是一些常用的，基本的操作，navicat还有很多人性化的操作。在这里就不多说了，有兴趣的朋友，可以下一个来玩玩。个人觉得用着挺爽的。</span></p> </div> </wbr>