History Report a problem
Article Edit this page Discussion

Capture SQL query output

From Vim Tips Wiki

Jump to: navigation, search
 

This page needs review for the following reasons:

  1. The page has been imported by a script and needs general review.
  2. The title may need to be fixed – see the title guidelines.
  3. Comments may need to be cleaned up – see the comment guidelines.

Here's what you can do:

  1. Improve the page and remove the {{Review}} line.
  2. Add suitable categories so people can find the tip.
  3. Remember to check what links here and the page history before renaming.
  4. Please avoid the discussion page for tips needing review.

Tip 104 • Previous Tip • Next Tip

Created: September 3, 2001 Complexity: advanced Author: meonkeys Minimum version: 5.7 Karma: 13/4 Imported from: Tip#104

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.

[edit] 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.

Retrieved from "http://vim.wikia.com/wiki/Capture_SQL_query_output"

Rate this article:

Share this article:
Hubs Highlights International Sites Wikia messages
Entertainment
Gaming
Cartoons & Comics
Science Fiction
Hobbies
Sports
See all... 		Grand Theft Auto
Terminator Wiki
Legend of Zelda Wiki
Flash Gordon
Everquest II Wiki
Yo-Yo Wiki
 German
Spanish
Chinese
Japanese
More... 		Wikia is hiring for several open positions
Send this article to a friend
"Capture SQL query output"
 
 
Hi!



I thought you'd like this page from Wikia!



http://vim.wikia.com



Come check it out!
Send confirmation

Back to article