On Wed, 24 Jan 2001, Marc Kidwell Pestana wrote:
> Try writing a PERL wrapper, that dumps the table to the screen and then
> pipe it to more
>
> % MyPerlwrapper -table <table name> | more
I think there is a perl wrapper somewhere (with msql-mysql-modules
perhaps?) but the original question begs the question: why doesn't the
mysql tool have a 'more' (paging) facility in interactive mode?(*) The
nearest approximation is to pipe into mysql with the tabel option
echo 'select foo, bar from widget' | mysql -t WOTSITS | more
or
echo 'explain widget' | mysql -t WOTSITS | more
> >Is there a user friendly utility that would allow one to display the
> >structure of a table or view the contents of one? Of course, this can
> >be done from within "mysql -p" but there is no way to pause at each
> >screen so most of my information scrolls off of the screen.
> >
> >I was trying with "mysqladmin <options> | more" but no success and I
> >don't see any examples in the manual. Example of what I tried was:
> >
> >mysqladmin my_db my_table | more
> >
> >but all I get is:
> >mysqladmin: connect to server at 'localhost' failed
> >error: 'Access denied for user: 'webmail@localhost' (Using password:
> >NO)'
(* OK so mySQL is opensource, so the answer to my question is obviously
"because no-one has thought fit to write one: why don't you?" :-)
regards,
--
John Stumbles [EMAIL PROTECTED]
I.T. Services Centre, University of Reading http://www.rdg.ac.uk/~visstmbl
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
never generalise
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
