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