mysql命令列裡的載入更多顯示

標籤：方便   integer   less   ssi   設定   for   cmd   repeat   arc   

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命令列裡的載入更多顯示