Changes: Capture SQL query output

Revision as of 03:05, 29 September 2008

Please review this tip:

This tip was imported from vim.org and needs general review.
You might clean up comments or merge similar tips.
Add suitable categories so people can find the tip.
Please avoid the discussion page (use the Comments section below for notes).
If the tip contains good advice for current Vim, remove the {{review}} line.

Tip 104 Printable Monobook Previous Next

created September 3, 2001 · complexity advanced · author meonkeys · version 5.7

DBI::Shell is a Perl module that is used as a shell interface to Perl's popular DBI (database interface) package. Forget your favorite SQL navigation gui and give this method a shot. This has only been tested in Unix.

1. Run dbish (runs DBI::Shell; installed with DBI::Shell) and connect to any database.

2. In dbish, set /format box.

3. Enter your query.

4. To execute query, type "/ | vim -"

This runs the query and pipes the output to the standard input of Vim.

Here are some follow-up tips:

Use gvim instead of Vim so a new window will pop up.
Set nowrap once in Vim.

Comments

Note that if your are using MySQL cli, you can type : "pager vim -" (without the quotes indeed).

Then every select, desc, show, etc. will be opened in Vim.

@@ Line 9: / Line 9: @@
 |version=5.7
 |rating=13/4
+|category1=
+|category2=
 }}
 DBI::Shell is a Perl module that is used as a shell interface to Perl's popular DBI (database interface) package. Forget your favorite SQL navigation gui and give this method a shot. This has only been tested in Unix.
@@ Line 27: / Line 29: @@
 ==Comments==
+Note that if your are using MySQL cli, you can type : "pager vim -" (without the quotes indeed).
+Then every select, desc, show, etc. will be opened in Vim.
+----