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 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 <[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
