Jonas,
Saturday, June 29, 2002, 12:20:41 PM, you wrote:
JO> I have just started to use MySQL and I have come up with a strange
JO> problem.
JO> I have a table with 28 rows. When I do 'SELECT * FROM table_name;' in
JO> the MySQL client it only shows 12 of these rows. But if i specify one of
JO> t
> 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
Just use that, and now it seems to work...
Thanks everyone...
//
Jonas
t; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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?
>
> M
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:
>
> --
> S
> 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 Olofs
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 11:20
Subject: Hidden rows i
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
t
