首页 > Linux操作系统 > Linux操作系统 > [20131211]mysql pager定义=vim.txt

[20131211]mysql pager定义=vim.txt

原创 Linux操作系统 作者:lfree 时间:2013-12-11 11:40:18 0 删除 编辑
[20131211]mysql pager定义=vim.txt

今天看厂家调试安全设备,发现后台数据库使用mysql。我发现他select * from 后,显示是的vim的编辑界面,感觉很有意思,

# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14542484 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use cacti
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> help

For the complete MySQL Manual online, visit:

For info on technical support from MySQL developers, visit:

For info on MySQL books, utilities, consultants, etc., visit:

List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
?         (\?) Synonym for `help'.
clear     (\c) Clear command.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set query delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute a SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.

For server side help, type 'help contents'


mysql> pager vim
mysql> select * from cdef;


mysql> pager vim -
mysql> select * from cdef;

--ok通过!很明显这个结果仅仅read only。这样设置vim只读
mysql> pager vim -R -c "set nowrap" -

pager=vim -R -c "set nowrap syntax=txt" -

--google 查询mysql pager 还可以发现许多有趣的例子。

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。


  • 博文量
  • 访问量