Mycli outputs query results in a pager (e.g.
allows you to easily view large result sets one page at a time.
Configuring the Pager
When starting up, mycli checks the
pager config option in MySQL's option
files. If it's set, then mycli uses its value as the pager. If it's blank,
then mycli will use the
PAGER environment variable's value.
Once mycli is started, you can use the
pager command to change which pager
mycli uses. Or,
nopager will disable the pager.
> pager less PAGER set to less. > nopager Pager disabled.
You can disable the pager by adding
skip-pager = on to the
of your MySQL option file. See Configuration for more information.
On macOS and Linux, the pager will default to
less for most users.
sometimes has less-than-desirable behavior like clearing the screen, cutting
lines off, etc. You can configure
less through environment variables in your
shell configuration files. Here are some common
less options and
-Xleaves file contents on the screen when less exits.
lessquit if the entire output can be displayed on one screen.
-Rdisplays ANSI color escape sequences in "raw" form.
-Sdisables line wrapping. Side-scroll to see long lines.
# This is a popular option among mycli users. export LESS="-XFR" # Some mycli users like to disable line wrapping. export LESS="-SRXF"