---

Ⅰ. 插件描述

Simple and Easy to use utility for executing MySQL queries

Ⅱ. 基本信息

创建日期：  2007-11-29 使用用户：  1 Github星：  1 插件作者：  Mantas Zimnickas

Ⅲ. 安装方法

使用Vundle管理器安装

在你的.vimrc下添加:

Plugin '/mysqlquery'

… 然后在Vim中运行以下命令:

:source %
:PluginInstall

对于Vundle版本 < 0.10.2，请用上面的Bundle替换Plugin。

使用NeoBundle管理器安装

在你的.vimrc下添加:

NeoBundle '/mysqlquery'

… 然后在Vim中运行以下命令:

:source %
:NeoBundleInstall

使用VimPlug管理器安装

在你的.vimrc下添加:

Plug '/mysqlquery'

… 然后在Vim中运行以下命令:

:source %
:PlugInstall

使用Pathogen管理器安装

在终端中运行以下命令:

cd ~/.vim/bundle
git clone https://github.com/vim-scripts/mysqlquery

Ⅳ. 文档说明

Simple and Easy to use utility for executing MySQL queries.

With this script comes only one function ExecMySQL(), so you need to bind a key to this function, for executing queries. For example:

:vmap <F9> :call ExecMySQL()<CR>
:nmap <F9> V:call ExecMySQL()<CR>

After that you need to write a SQL query, then select it (or if query consist only of one line, point cursor to it) ant press <F9>.

Query will be executed and in new buffer you will see result of that query. Results are shown in beautifully aligned table.

Best way to work with this plug-in is separate file for queries. At the beginning of that file, in one of 10 first lines you need to add connection string:

-- mysql://username:password@hostname/dbname

You can add many connection strings, but only first found string will be used. So if you want to change database, just move connection string at the very top of file.

Also I suggesting you to use this mapping for better usage:

map <F5> :b#<CR>

With this mapping, after executing a query, you can easily switch back to query editing, just by pressing <F5>.