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