Mysql: Show limited records in mysql shell?

Question

When I run this

mysql > show tables;

It lists all tables, I don't see the first one.

How do I restrict entries like we do less

in Linux?

Thank!

+3

Ahsan Feb 19 At 7:45 am

1 answer

Bill karwin · Accepted Answer · 2013-02-19T07:46:59+0000

You can install pager in mysql client.

mysql> pager less
mysql> show tables;
. . .
mysql> nopager

In fact, you can set pager

for any shell command that you would normally use in a pipeline.
For example grep.