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.

----- Original Message -----
From: "Jonas Olofsson" <jonolo@xxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Saturday, June 29, 2002 11:20
Subject: Hidden rows in table.


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