Re: Hidden rows in table.

Hi,

Perhaps the table is corrupted ? (the second query uses index if they is one
whereas the first doesn't).
REPAIR TABLE reports nothing wrong ?

Regards,
  Jocelyn
----- Original Message -----
From: "Mikhail Entaltsev" <mike_lynx@xxxxxxx>
To: "Jonas Olofsson" <jonolo@xxxxxxx>; <mysql@xxxxxxxxxxxxxxx>
Sent: Saturday, June 29, 2002 5:26 PM
Subject: Re: Hidden rows in table.


> Jonas,
>
> I think that the problem is not in MySQL server, but may be it is in MySQL
> client.
> Do you use standard (command line) MySQl client?
>
> Mikhail.
>
> ----- Original Message -----
> From: "Jonas Olofsson" <jonolo@xxxxxxx>
> To: <mysql@xxxxxxxxxxxxxxx>
> Sent: Saturday, June 29, 2002 16:39
> Subject: RE: Hidden rows in table.
>
>
> > > Jonas,
> > >
> > > try to execute this command:
> > >
> > > SELECT count(1) FROM table_name;
> > >
> > > Result should be 28. Do you have 28?
> > >
> > > Mikhail.
> >
> > Yes, it says:
> >
> > --
> > SELECT count(1) FROM table_name;
> >
> > +----------+
> > | count(1) |
> > +----------+
> > |       28   |
> > +----------+
> > 1 row in set (0.00 sec)
> > --
> > //
> > Jonas Olofsson
> >
> > > > Hi.
> > > >
> > > > I have just started to use MySQL and I have come up with a strange
> > > > problem.
> > > >
> > > > I have a table with 28 rows. When I do 'SELECT * FROM
> > > table_name;' in
> > > > the MySQL client it only shows 12 of these rows. But if i
> > > specify one
> > > > of the rows that are not shown with the first command, like
> > > 'SELECT *
> > > > FROM table_name WHERE id='25';' this row is shown.
> > > >
> > > > Any suggestions what might be wrong?
> > > >
> > > > //
> > > > Jonas Olofsson
> > > >
> > > >
> > > >
> > > ---------------------------------------------------------------------
> > > > 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 <mysql-thread113388@xxxxxxxxxxxxxxx>
> > > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-mike_lynx=smtp.ru@xxxxxxxxxxxxxxx>
> > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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 <mysql-thread113391@xxxxxxxxxxxxxxx>
> > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-jonolo=home.se@xxxxxxxxxxxxxxx>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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 <mysql-thread113397@xxxxxxxxxxxxxxx>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-mike_lynx=smtp.ru@xxxxxxxxxxxxxxx>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread113398@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>


---------------------------------------------------------------------
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 <mysql-thread113399@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php