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" <[EMAIL PROTECTED]> To: "Jonas Olofsson" <[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? > > Mikhail. > > ----- Original Message ----- > From: "Jonas Olofsson" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > 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 <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > 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 <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
