[20131211]mysql pager定义＝vim.txt
今天看厂家调试安全设备，发现后台数据库使用mysql。我发现他select * from 自己一点也不熟悉mysql，不过我在公司使用cacti监控各种设备以及服务器，自己也测试看看。
# 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:
http://www.mysql.com/documentation
For info on technical support from MySQL developers, visit:
http://www.mysql.com/support
For info on MySQL books, utilities, consultants, etc., visit:
http://www.mysql.com/portal
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'
--很明显修改pager参数就可以实现。
我执行如下：
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" -
--可惜oracle没有这个特性。如果要永久有效，加入/etc/my.cnf文件中加入如下：
[mysql]
pager=vim -R -c "set nowrap syntax=txt" -
--google 查询mysql pager 还可以发现许多有趣的例子。
今天看厂家调试安全设备，发现后台数据库使用mysql。我发现他select * from 自己一点也不熟悉mysql，不过我在公司使用cacti监控各种设备以及服务器，自己也测试看看。
# 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:
http://www.mysql.com/documentation
For info on technical support from MySQL developers, visit:
http://www.mysql.com/support
For info on MySQL books, utilities, consultants, etc., visit:
http://www.mysql.com/portal
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'
--很明显修改pager参数就可以实现。
我执行如下：
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" -
--可惜oracle没有这个特性。如果要永久有效，加入/etc/my.cnf文件中加入如下：
[mysql]
pager=vim -R -c "set nowrap syntax=txt" -
--google 查询mysql pager 还可以发现许多有趣的例子。
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-1062965/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
<%=items[i].createtime%>
<%=items[i].content%>
<%if(items[i].items.items.length) { %>
<%for(var j=0;j
<%}%> <%if(items[i].items.total > 5) { %>
<%}%> <%}%>
<%=items[i].items.items[j].createtime%>
回复
<%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%>
还有<%=items[i].items.total-5%>条评论
) data-count=1 data-flag=true>点击查看
<%}%>
最新文章
- [20190827]函数索引与选择率.txt
- [20190826]update结果集2.txt
- [20190825]Join View and delete.txt
- [20190823]关于CPU成本计算2.txt
- [20190821]关于CPU成本计算.txt
- [20190819]如何快速转换16进制串到字符串.txt
- [20190816]12c执行exec SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS()报错.txt
- [20190815]索引快速全扫描的成本.txt
- [20190810]如何索引一个超长字段.txt
- [20190805]Oracle 12c New Feature – Online Partitioning.txt
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备09055130号-4 北京市公安局海淀分局网监中心备案编号：11010802021510
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
转载于:http://blog.itpub.net/267265/viewspace-1062965/
1175
到【灌水乐园】发言
