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 "|" --column-mode --column-rainbow --align'
You can also write in ~/.my.cnf
.
[client]
pager=ov -w=f -H3 -F -C -d "|" --column-mode --column-rainbow --align
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 "|" --column-mode --column-rainbow --align'
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 --column-mode --column-rainbow --align")
SQL mode and Python mode.
\option --persist pager "ov -w=f -H1 --skip-lines 1 -F -C -d '|' --column-mode --column-rainbow --align"
Also, from v0.37.0, if you use --align
, you can shrink the columns (default key s
).