mysql
Posted on:
ov
can be used as a pager for mysql or MySQL Shell.
Use the –pager option with the mysql client.
mysql --pager='ov -w=f -H3 -F -C -d "|"'
You can also write in ~/.my.cnf
.
[client]
pager=ov -w=f -H3 -F -C -d "|"
The header line for mysql is 3, but it’s surrounded by a separator line. You can increase the display area by setting the skip line to 1 and the header to 1.
ov -w=f --skip-lines 1 -H1 -F -C -d "|"'
For mysqlsh, use the --pager
option or set it while mysqlsh is running.
For example, in js mode, it can be made persistent by the following command.
shell.options.setPersist("pager","ov -H1 --skip-lines 1 -C -w=false -d'|' -F")
SQL mode and Python mode.
\option --persist pager "ov -w=f -H1 --skip-lines 1 -F -C -d '|'"