大网数据广告活动
服务器运维问答

How do I set MySQL CLI to use pager output by default?

· 52CE 我爱测

I found this wonderful output format for the MySQL CLI here . The command is mysql> pager less -SFX . I would like this to be my default and not have to enter the command every time I start the MySQL CLI. How can I go about setti…

问题原文

原帖链接 · Tony · CC BY-SA 4.0

I found this wonderful output format for the MySQL CLI here. The command is mysql> pager less -SFX. I would like this to be my default and not have to enter the command every time I start the MySQL CLI. How can I go about setting this as a default?

已采纳解答

原帖链接 · HBruijn · CC BY-SA 4.0

The pager can be set from the mysql client commandline with the --pager= option.

So one option is setting up an alias in your shell such that your custom pager is always set in your ~/.bashrc something similar to :

alias mysql='mysql --pager="/usr/bin/less -SFX"'

Alternatively any --option= commandline option can be set as option= in the relevant section of your personal ~/.my.cnf file. For instance:

[mysql]
pager="/usr/bin/less -SFX" 

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2019-02-27)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。