MySQL equivalent to *nix 'more'

[Gnurp Gnarp]

How do I prevent the MySQL client to scroll pages when the results of
a query exceeds the number of lines in the terminal window?

Like a MySQL equivalent to *nix 'more'.

mysql> select foo from bar;
[...]

2500 rows in set (0.00 sec)
--

[Thomas Bartkus]

"Gnurp Gnarp" <gn************ *@hotmail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

How do I prevent the MySQL client to scroll pages when the results of
a query exceeds the number of lines in the terminal window?

Like a MySQL equivalent to *nix 'more'.

mysql> select foo from bar;
[...]

Read up on LIMIT.

You can pass it a number of rows to skip over as well as the number of rows
to retrieve.
This allows you to paginate through large tables 50 (or whatever) records at
a time.

Thomas Bartkus

[MikeA]

You can use the pager command '\P' to set the paging program:

MySQL>\P more

will use the OS's 'more' command to page the output.
Regards,

Mike Argy
Custom Office Solutions
and UNIX/Windows applications

On Thu, 27 Jan 2005 06:45:02 -0800, Gnurp Gnarp wrote:

How do I prevent the MySQL client to scroll pages when the results of
a query exceeds the number of lines in the terminal window?

Like a MySQL equivalent to *nix 'more'.

mysql> select foo from bar;
[...]

2500 rows in set (0.00 sec)
--