mysql> pager more
PAGER set to ‘more‘
mysql> pager less
PAGER set to ‘less‘
mysql> nopager
PAGER set to stdout

mysql pager的三个状态

设置

mysql> pager more
PAGER set to ‘more‘

然后进行查询,我们的结果就不会一真往上闪了,只会显示第一页,如果还想看下面的数据,就按回车键吧

这样问题来了,总不能几十万行,让我一行行往下看吧???

这时就要用到帮助了,在查询结果下面出来了

--More--

以后,按一下h
Most commands optionally preceded by integer argument k. Defaults in brackets.
Star (*) indicates argument becomes new default.
-------------------------------------------------------------------------------
<space> Display next k lines of text [current screen size]
z Display next k lines of text [current screen size]*
<return> Display next k lines of text [1]*
d or ctrl-D Scroll k lines [current scroll size, initially 11]*
q or Q or <interrupt> Exit from more
s Skip forward k lines of text [1]
f Skip forward k screenfuls of text [1]
b or ctrl-B Skip backwards k screenfuls of text [1]
‘ Go to place where previous search started
= Display current line number
/<regular expression> Search for kth occurrence of regular expression [1]
n Search for kth occurrence of last r.e [1]
!<cmd> or :!<cmd> Execute <cmd> in a subshell
v Start up /usr/bin/vi at current line
ctrl-L Redraw screen
:n Go to kth next file [1]
:p Go to kth previous file [1]
:f Display current file name and line number
. Repeat previous command
-------------------------------------------------------------------------------
--More--

所有的帮助都在这了,不知道的就看一下

感觉还是很方便的

mysql命令行里的加载更多显示