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