List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:June 14 2002 11:26am
Subject:Re: Is this an FAQ?
View as plain text  
Phil,
Friday, June 14, 2002, 6:14:49 AM, you wrote:

PR> I've been trying to "select * table" as a way to review a large table in 
PR> mysql.  But only 1000 rows are returned, whereas there should be about 1200 
PR> rows in all.  Is this a limitation in mysql?  Is there a configuration file 
PR> where it can be reset to a higher value?  Thanks in advance. Phil Reardon

No, there is no such limitations in MySQL. Are you sure that table
contains about 1200 rows? What is the result of
         SELECT COUNT(*) FROM table_name





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com


Thread
Is this an FAQ?Phil Reardon14 Jun
  • Re: Is this an FAQ?Dan Nelson14 Jun
  • Re: Is this an FAQ?Egor Egorov14 Jun