From: Mike Johnson > From: Adel Ardalan [mailto:[EMAIL PROTECTED] > > > When I select a rather large table to be shown, the rows are > > going very fast and I can't see the rows at the beginning. > > Also, I can't scroll up. How can I view the results page by > > page? > > > I can only assume you're talking about the native mysql > client. In that case, there are a few suggestions to help you. > > If possible, first weed out rows you don't need with a WHERE clause. > > If there's still too much data, add a `LIMIT > <offset>,<count>` clause to the end of the query. > > SELECT * FROM table LIMIT 0,30; > SELECT * FROM table LIMIT 30,30; > SELECT * FROM table LIMIT 60,30; > > etc > > Or, if possible, increase the scrollback buffer for your > shell client (if you're shelled in, that is, and not on the > server directly). > > As it stands, though, the native mysql client really isn't > meant to be used to view such large amounts of data. Are you > using any sort of frontend with this database? PHP, Perl, Java, etc?
Oh, one more... SELECT * FROM table INTO OUTFILE '/path/to/file'; Then exit the mysql client and use (if on a *nix or Windows system) `more /path/to/file` to page through the results of the table dump. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
