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]