SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast Angrypoonani's Avatar
    Join Date
    Mar 2011
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question "SELECT *" yields too many rows to show! How do I scroll through all results?

    When I use: SELECT * FROM download_log;
    I have 1300+ rows of data but using putty I cannot scroll to the top of the results, I can only see about 100 results!

    How do I scroll through the rest of them?

    or should I write up a php script to display this information on a page?

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,904
    Mentioned
    93 Post(s)
    Tagged
    0 Thread(s)
    Do you have PHPMyAdmin available to you to access the database concerned?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Enthusiast Angrypoonani's Avatar
    Join Date
    Mar 2011
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No I do not use phpAdmin i just use the putty command prompt to access my server and MySQL db. I am under the impression that phpAdmin is not free.

  4. #4
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That impression would be incorrect. PHPMyadmin is free tool and should be included from your host if you have access to mysql via cpanel.

  5. #5
    SitePoint Enthusiast Angrypoonani's Avatar
    Join Date
    Mar 2011
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by guelphdad View Post
    That impression would be incorrect. PHPMyadmin is free tool and should be included from your host if you have access to mysql via cpanel.
    While I fool around with installing PHPMyAdmin....

    I am still curious if anyone knows a way to scroll through many rows of data in a table using the bash shell command prompt interface?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •