There is no \P command in the Windows version of MySQL (as of 4.x). It would
be a nice addition, since there is a more command in the Windows CLI, but
I'm not sure how (or if) the piping can be set up in Windows.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341


> -----Original Message-----
> From: Baron Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 03, 2007 8:42 AM
> To: [EMAIL PROTECTED]
> Cc: MySQL
> Subject: Re: Less | More
>
> John Kebbel wrote:
> > Is there a mysql command line equivalent to | less or |
> more to make it
> > easier to scan rows one screen at a time?
> >
> >
>
> Type ? from within the command-line client to see help.  One
> of the lines shows this:
>
> pager     (\P) Set PAGER [to_pager]. Print the query results
> via PAGER.
>
> On Linux, when I just type \P, it does this:
>
> mysql> \P
> PAGER set to '/usr/bin/less'
> mysql>
>
> Every query thereafter runs through less.
>
> Baron
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to