Re: Less | More

[Baron Schwartz]

John Kebbel wrote:
> Is there a mysql command line equivalent to | less or | more to make it
> easier to scan rows one screen at a time? 
> 
> 

Type ? from within the command-line client to see help.  One of the lines shows this:

pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.

On Linux, when I just type \P, it does this:

mysql> \P
PAGER set to '/usr/bin/less'
mysql>

Every query thereafter runs through less.

Baron